private void button1_Click(object sender, EventArgs e) { mycls.工号 = txt_workno.get_value(); mycls.收入 = double.Parse(txt_income.get_value().ToString()); mycls.日期 = mydate.Value; mycls.类型 = cmb_type.SelectedItem.ToString(); mycls.重量 = double.Parse(txt_weight.get_value()); mycls.台份 = txt_taifen.get_value(); mycls.主机厂 = ""; if (addflag) { mycls.Id = Guid.NewGuid(); dal.Add(mycls); } else { dal.Update(mycls); } groupBox1.Enabled = false; fill(txt_searchworkno.get_value()); }
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; }