private void fill(DateTime mydate)
{
每月收入DAL dal = new 每月收入DAL();
data_grd.set_date(dal.GetAllDataTable(mydate));
data_grd.set_hide(0);
}
private void import_file(string filename)
{
List <每月收入> mylist = new List <每月收入>();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataReader dr;
OleDbCommand myCommand = new OleDbCommand();
strExcel = @"select rtrim(工号), rtrim(台份),
iif(isnull(吨位), 0, 吨位),iif(isnull(收入),0, 收入), iif(isnull(欧元),0,欧元), iif(isnull(美元),0,美元) from [工号信息$]";
myCommand.Connection = conn;
myCommand.CommandText = strExcel;
dr = myCommand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
mycls = new 每月收入();
mycls.Id = Guid.NewGuid();
mycls.工号 = dr.GetString(0).Trim();
//mycls.台份 = dr.GetString(1);
mycls.台份 = "1";
mycls.主机厂 = "";
mycls.收入 = double.Parse(dr.GetValue(3).ToString());
mycls.重量 = double.Parse(dr.GetValue(2).ToString());
mycls.类型 = mytype;
mycls.美元 = double.Parse(dr.GetValue(5).ToString());
mycls.欧元 = double.Parse(dr.GetValue(4).ToString());
mycls.日期 = mydate.Value;
mylist.Add(mycls);
}
}
dr.Close();
// 以下为检查导入数据
工号表DAL ghdal = new 工号表DAL();
每月收入DAL dal = new 每月收入DAL();
bool wrongflag = false;
string wrongworkno = "";
foreach (每月收入 mycls1 in mylist)
{
if (!ghdal.IsIn工号表(mycls1.工号))
{
//MessageBox.Show("工号 ：" + mycls1.工号 + " 不存在 ！");
wrongflag = true;
wrongworkno += mycls1.工号 + "\r\n";
}
}
if (wrongflag)
{
MessageBox.Show(wrongworkno, "错误工号");
System.IO.FileStream fs = new System.IO.FileStream("E:/WRONG.TXT", System.IO.FileMode.OpenOrCreate);
byte[] data = System.Text.Encoding.Default.GetBytes(wrongworkno);
fs.Write(data, 0, data.Length);
fs.Close();
return;
}
foreach (每月收入 mycls1 in mylist)
{
dal.Add(mycls1);
}
return;
}
