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);
}
}