读取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();
}
}
}
}
评论