//新增資料
public void InsertStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = new Repository.Entity.Student();
student.Student_No = GetNewStudentNo();
student.Student_Name = Name;
student.Student_Birthday = Convert.ToDateTime(Birthday);
student.Student_Email = Email;
DBEntity.Student.Add(student);
DBEntity.SaveChanges();
}
}
private void BtnManual_Click(object sender, EventArgs e)
{
ManualForm manualForm = new ManualForm();
// 获得调出学生和班级
int id = 0;
int.TryParse(this.dgClassStudent.SelectedRows[0].Cells["s_id"].Value.ToString(), out id);
Repository.Student repoStudent = new Student();
Repository.Entity.Student s = repoStudent.GetList("ID=" + id)[0];
manualForm.OldStudent = s;
int.TryParse(this.dgClass.SelectedRows[0].Cells[0].Value.ToString(), out id);
Repository.Class repoClass = new Class();
Repository.Entity.Class c = repoClass.GetList("ID=" + id)[0];
manualForm.OldClass = c;
manualForm.ShowDialog();
}
private void BtnImport_Click(object sender, EventArgs e)
{
if (MessageBox.Show("导入数据需要几分钟时间，原有数据将被清空。\n是否确认？", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
// 读取excel，插入数据库，然后再说别的
Repository.Student repoStudent = new Student();
// 清空原有记录
repoStudent.Clear();
int cnt = 0;
DataTable dt = ExcelHelper.ExcelToDataTableFormPath(this.txtFileName.Text, true, 0); //学生数据须为第一张sheet
foreach (DataRow dr in dt.Rows)
{
Repository.Entity.Student s = new Repository.Entity.Student();
s.bddd = dr["bddd"] == null ? "" : dr["bddd"].ToString();
s.bdrq = dr["bdrq"] == null ? DateTime.Today : DateTime.Parse(dr["bdrq"].ToString());
s.csrq = dr["csrq"] == null ? DateTime.Today : DateTime.Parse(dr["csrq"].ToString());
s.czbyxx = dr["czbyxx"] == null ? "" : dr["czbyxx"].ToString();
s.dq = dr["dq"] == null ? "" : dr["dq"].ToString();
s.fqxm = dr["fqxm"] == null ? "" : dr["fqxm"].ToString();
s.gzlqsj = dr["gzlqsj"] == null ? DateTime.Today : DateTime.Parse(dr["gzlqsj"].ToString());
s.gzlqxxdm = dr["gzlqxxdm"] == null ? "" : dr["gzlqxxdm"].ToString();
s.gzlqxx = dr["gzlqxx"] == null ? "" : dr["gzlqxx"].ToString();
s.hkxz = dr["hkxz"] == null ? "" : dr["hkxz"].ToString();
s.hx = dr["hx"] == null ? 0 : float.Parse(dr["hx"].ToString());
s.jtcs = dr["jtcs"] == null ? "" : dr["jtcs"].ToString();
s.kslb = dr["kslb"] == null ? "" : dr["kslb"].ToString();
s.kstz = dr["kstz"] == null ? "" : dr["kstz"].ToString();
s.ksyz = dr["ksyz"] == null ? "" : dr["ksyz"].ToString();
s.ksztdm = dr["ksztdm"] == null ? "" : dr["ksztdm"].ToString();
s.lxdh = dr["lxdh"] == null ? "" : dr["lxdh"].ToString();
s.mqxm = dr["mqxm"] == null ? "" : dr["mqxm"].ToString();
s.mz = dr["mz"] == null ? "" : dr["mz"].ToString();
//s.sfbd = dr["sfbd"] == null ? "" : dr["sfbd"].ToString();
//s.sfwk = dr["sfwk"] == null ? "" : dr["sfwk"].ToString();
s.sfzh = dr["sfzh"] == null ? "" : dr["sfzh"].ToString();
s.sx = dr["sx"] == null ? 0 : float.Parse(dr["sx"].ToString());
s.txdz = dr["txdz"] == null ? "" : dr["txdz"].ToString();
s.tzf = dr["tzf"] == null ? 0 : float.Parse(dr["tzf"].ToString());
s.wl = dr["wl"] == null ? 0 : float.Parse(dr["wl"].ToString());
s.wy = dr["wy"] == null ? 0 : float.Parse(dr["wy"].ToString());
s.xb = dr["xb"] == null ? "" : dr["xb"].ToString();
s.xjh = dr["xjh"] == null ? "" : dr["xjh"].ToString();
s.xm = dr["xm"] == null ? "" : dr["xm"].ToString();
s.xq = dr["xq"] == null ? "" : dr["xq"].ToString();
s.yw = dr["yw"] == null ? 0 : float.Parse(dr["yw"].ToString());
s.yzbm = dr["yzbm"] == null ? "" : dr["yzbm"].ToString();
s.zf = dr["zf"] == null ? 0 : float.Parse(dr["zf"].ToString());
s.zkksh = dr["zkksh"] == null ? "" : dr["zkksh"].ToString();
s.zz = dr["zz"] == null ? 0 : float.Parse(dr["zz"].ToString());
s.zzmm = dr["zzmm"] == null ? "" : dr["zzmm"].ToString();
try
{
repoStudent.Add(s);
cnt++;
}
catch (Exception ex)
{
MessageBox.Show("数据导入错误。\n第" + (cnt + 1).ToString() + "行。\n" + ex.Message + "\n请查看出错数据并尝试重新导入。");
return;
}
}
MessageBox.Show("导入完成。共导入" + cnt + "条记录。");
this.BindStudent();
this.lblTotalStudents.Text = ((List <Repository.Entity.Student>) this.dgStudent.DataSource).Count.ToString();
}
