private void buttonOK_Click(object sender, EventArgs e) { DateTime nowTime = DateTime.Now; string name = textBox1.Text; string description = textBox2.Text; if (name == "") { MessageBox.Show("姓名不能为空!"); textBox1.SelectAll(); textBox1.Focus(); return; } BaseInfoMemberTester bimt = BaseInfoMemberTester.New; bimt.Name = name; if (description == "") { bimt.Description = "无"; } else { bimt.Description = description; } bimt.PinYin = AutoPinYin.GetPinYin(name); bimt.Mobile = Mobile; bimt.TestDate = nowTime; bimt.FinishedDate = nowTime.AddHours(1); bimt.Status = "0"; bimt.OptrType = UserStatics.OptrType; bimt.Save(); MessageBox.Show("录入完成,请您入园体验!"); this.Close(); }
protected override void SetImportOptration() { try { OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { DataSet ds = new DataSet(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + ofd.FileName + ";" + "Extended Properties='Excel 8.0;HDR=yes;IMEX=1'"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; strExcel = string.Format("select * from [{0}$]", "Sheet1"); //Sheet1为excel中工作薄 myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, "Sheet1"); DataTable dt = ds.Tables["Sheet1"]; Encoding gb2312 = Encoding.GetEncoding("GB2312"); for (int iRow = 0; iRow < dt.Rows.Count; iRow++) { BaseInfoMemberTester bifmt = BaseInfoMemberTester.New; bifmt.Mobile = dt.Rows[iRow][0].ToString(); bifmt.Name = dt.Rows[iRow][1].ToString(); bifmt.Description = dt.Rows[iRow][2].ToString(); bifmt.PinYin = PinYinTransfer.GetInitials(bifmt.Name, gb2312); bifmt.TestDate = (DateTime)dt.Rows[iRow][3]; bifmt.FinishedDate = (DateTime)dt.Rows[iRow][4]; bifmt.Status = "0"; bifmt.OptrType = UserStatics.OptrType; bifmt.Save(); } } MessageBox.Show("导入成功!"); } catch (Exception ex) { MessageBox.Show("导入有问题,日期精确到秒,日期列要设为日期格式,并且数值类型如没有必须用0代替!\n" + ex); } }