实例介绍
【实例简介】
读取excel里的型号和扫码出来的型号进行比对
【实例截图】
【核心代码】
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MyOraComm;
using DevComponents.DotNetBar;
using System.Data.OleDb;
using System.IO;
using Microsoft.Office.Interop.Excel;
namespace Cognex.DataMan.SDK
{
public partial class Login : Office2007Form
{
public Login()
{
InitializeComponent();
}
private void btnLogin_Click(object sender, EventArgs e)
{
conn con = new conn();
DataSet ds = new DataSet();
string strDataSetName = "win_auth";
string strUserName = this.txtName.Text;
string strUserPassword = this.txtPwd.Text;
string strTablepwd = "";
string strType = "";
// 验证用户输入是否为空，若为空，提示用户信息
if (strUserName.Equals("") || strUserPassword.Equals(""))
{
label5.Text = "工号或密码不能为空！";
}
else
{
label5.Text = "";
//读取数据库中用户名的密码和用户名的类型
string strSql = "select dp_resp_id,dp_resp_username,dp_resp_passwd,dp_resp_lx,dp_resp_remark from win_auth where dp_resp_username='" strUserName "'";
ds = con.ReturnDataSet(strSql, strDataSetName);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 )
{
strTablepwd =Convert.ToString(ds.Tables[0].Rows[0]["dp_resp_passwd"]);
strType = Convert.ToString(ds.Tables[0].Rows[0]["dp_resp_lx"]);
}
//密码不正确
if (strUserPassword != strTablepwd)
{
label5.Text = "工号或密码不正确，请重新输入！";
}
else
{
this.Hide();
//管理员
//if ("管理员" == strType)
//{
// Manage frmManage = new Manage(strUserName);
// frmManage.Show();
//}
//操作员
//else
//{
OprParmaSet frmOprParmaSet = new OprParmaSet(strUserName);
frmOprParmaSet.Show();
//}
}
}
}
private void dispose()
{
conn con = new conn();
string FieldsName = "";
string FieldsValue = "";
string strFlg = "0";
int id = 1;
string res = "";
EditText et = new EditText();
et.TableName = "win_recordflg";
string strSql = @" delete from win_recordflg where 1=1";
int re = con.ExecuteSQL(strSql);
res = con.GetMaxValue("win_recordflg", "dp_resp_id");
if ("" != res)
{
id = Int32.Parse(res) 1;
}
FieldsName = "dp_resp_id,dp_resp_flg,dp_resp_remark";
FieldsValue = id "," strFlg "," "";
et.saveadd(FieldsName, FieldsValue);
this.Dispose();
this.Close();
System.Environment.Exit(0);
}
private void btnCancel_Click(object sender, EventArgs e)
{
//关闭登录界面
dispose();
}
private void Login_FormClosed(object sender, FormClosedEventArgs e)
{
dispose();
}
private void txtName_Validated(object sender, EventArgs e)
{
string strUserName = this.txtName.Text;
if (strUserName.Equals(""))
{
label5.Text = "工号不能为空！";
}
else
{
label5.Text = "";
}
}
private void txtPwd_Validated(object sender, EventArgs e)
{
string strUserPassword = this.txtPwd.Text;
if (strUserPassword.Equals(""))
{
label5.Text = "密码不能为空！";
}
else
{
label5.Text = "";
}
}
private void ReadExcel()
{
string strWorkCtr = "";
string strPlanid = "";
string strWorkOrder = "";
string strItemNumber = "";
string strDescription = "";
string strOrdered = "";
string strCompletequantity = "";
string strUnCompletequantity = "";
string strDue = "";
string strSql = "";
int re = 0;
conn con = new conn();
string FieldsName = "";
string FieldsValue = "";
int id = 1;
string res = "";
EditText et = new EditText();
et.TableName = "win_plan";
string strDate = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string Path = "D:\\work\\项目\\沃联的AO史密斯项目\\计划表.xlsx";
string strBackFilePath = System.Windows.Forms.Application.StartupPath "\\BackFile\\" "计划表_" strDate ".xlsx";
string strDestPath = System.Windows.Forms.Application.StartupPath "\\" "计划表.xls";
File.Copy(Path, strBackFilePath,true);
System.IO.FileInfo file = new System.IO.FileInfo(strDestPath);
if (file.Exists)
{
file.Delete();
}
object oMissing = Type.Missing;
var app = new Microsoft.Office.Interop.Excel.Application();
var wb = app.Workbooks.Open(strBackFilePath, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
wb.SaveAs(strDestPath, XlFileFormat.xlExcel8, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
app.Quit();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" "Data Source=" strDestPath ";" "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
try
{
conn.Open();
strSql = @" delete from win_plan where 1=1";
re = con.ExecuteSQL(strSql);
}
catch
{
}
finally
{
}
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel = "select * from [Sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds, "table1");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i )
{
strWorkCtr = Convert.ToString(ds.Tables[0].Rows[i]["Work Ctr"]);
strPlanid = Convert.ToString(ds.Tables[0].Rows[i]["ID"]);
strWorkOrder = Convert.ToString(ds.Tables[0].Rows[i]["Work Order"]);
strItemNumber = Convert.ToString(ds.Tables[0].Rows[i]["Item Number"]);
strDescription = Convert.ToString(ds.Tables[0].Rows[i]["Description"]);
strOrdered = Convert.ToString(ds.Tables[0].Rows[i]["Ordered"]);
strCompletequantity = Convert.ToString(ds.Tables[0].Rows[i]["完成数量"]);
strUnCompletequantity = Convert.ToString(ds.Tables[0].Rows[i]["未完成数量"]);
strDue = Convert.ToString(ds.Tables[0].Rows[i]["Due"]);
res = con.GetMaxValue("win_plan", "dp_resp_id");
if ("" != res)
{
id = Int32.Parse(res) 1;
}
FieldsName = "dp_resp_id,dp_resp_workctr,dp_resp_planid,dp_resp_workorder,dp_resp_itemnumber,dp_resp_description,dp_resp_ordered,dp_resp_completequantity,dp_resp_uncompletequantity,dp_resp_due,dp_resp_remark,dp_resp_remark1,dp_resp_remark2,dp_resp_remark3,dp_resp_remark4,dp_resp_remark5";
FieldsValue = id "," strWorkCtr "," strPlanid "," strWorkOrder "," strItemNumber "," strDescription "," strOrdered "," strCompletequantity "," strUnCompletequantity "," strDue "," "" "," "" "," "" "," "" "," "" "," "";
et.saveadd(FieldsName, FieldsValue);
}
}
strSql = @" delete from win_recordflg where 1=1";
re = con.ExecuteSQL(strSql);
FieldsName = "";
FieldsValue = "";
string strFlg = "1";
id = 1;
res = "";
et.TableName = "win_recordflg";
res = con.GetMaxValue("win_recordflg", "dp_resp_id");
if ("" != res)
{
id = Int32.Parse(res) 1;
}
FieldsName = "dp_resp_id,dp_resp_flg,dp_resp_remark";
FieldsValue = id "," strFlg "," "";
et.saveadd(FieldsName, FieldsValue);
}
private void Login_Load(object sender, EventArgs e)
{
this.ControlBox = false;
conn con = new conn();
DataSet ds = new DataSet();
string strDataSetName = "win_recordflg";
string strFlg = "";
string strSql = "select dp_resp_id,dp_resp_flg,dp_resp_remark from win_recordflg ";
ds = con.ReturnDataSet(strSql, strDataSetName);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
strFlg = Convert.ToString(ds.Tables[0].Rows[0]["dp_resp_flg"]);
}
if ("0" == strFlg || "" == strFlg)
{
ReadExcel();
}
}
}
}
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论