private void run_upload_data(DataSet Excelds) { int i = 0; string name = ""; string stuno = ""; string ksno = ""; string CardID = ""; string score = ""; string luquxueyuan = ""; string luquzhuanye = ""; string kstype = ""; zs.Model.Tbl_Chaxun chaxun = new zs.Model.Tbl_Chaxun(); //PJXT.Model.teacher teacher = new PJXT.Model.teacher(); //PJXT.Model.classes classes = new PJXT.Model.classes(); //PJXT.Model.student student = new PJXT.Model.student(); while (i < Excelds.Tables[0].Rows.Count) { name = Excelds.Tables[0].Rows[i][0].ToString(); stuno = Excelds.Tables[0].Rows[i][1].ToString(); ksno = Excelds.Tables[0].Rows[i][2].ToString(); CardID = Excelds.Tables[0].Rows[i][3].ToString(); score = Excelds.Tables[0].Rows[i][4].ToString(); luquxueyuan = Excelds.Tables[0].Rows[i][5].ToString(); luquzhuanye = Excelds.Tables[0].Rows[i][6].ToString(); kstype = Excelds.Tables[0].Rows[i][7].ToString(); if (bll.GetModelList("cardid='" + CardID + "'").Count > 0) { chaxun = bll.GetModelList("cardid='" + CardID + "'")[0]; chaxun.name = name; chaxun.stuno = stuno; chaxun.ksno = ksno; chaxun.cardid = CardID; chaxun.score = score; chaxun.luquxueyuan = luquxueyuan; chaxun.luquzhuanye = luquzhuanye; chaxun.kstype = kstype; bll.Update(chaxun); } else { chaxun.name = name; chaxun.stuno = stuno; chaxun.ksno = ksno; chaxun.cardid = CardID; chaxun.score = score; chaxun.luquxueyuan = luquxueyuan; chaxun.luquzhuanye = luquzhuanye; chaxun.kstype = kstype; bll.Add(chaxun); } i++; } this.lb_Result.Text = "共新增数据:" + i + "条。"; BindData(); //Allusers.WriteLogsFile("管理员,导入学生" + i + "个成功!IP:" + Request.UserHostAddress.ToString()); }
/// <summary> /// 获得数据列表 /// </summary> public List <zs.Model.Tbl_Chaxun> DataTableToList(DataTable dt) { List <zs.Model.Tbl_Chaxun> modelList = new List <zs.Model.Tbl_Chaxun>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { zs.Model.Tbl_Chaxun model; for (int n = 0; n < rowsCount; n++) { model = new zs.Model.Tbl_Chaxun(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["name"] != null && dt.Rows[n]["name"].ToString() != "") { model.name = dt.Rows[n]["name"].ToString(); } if (dt.Rows[n]["stuno"] != null && dt.Rows[n]["stuno"].ToString() != "") { model.stuno = dt.Rows[n]["stuno"].ToString(); } if (dt.Rows[n]["ksno"] != null && dt.Rows[n]["ksno"].ToString() != "") { model.ksno = dt.Rows[n]["ksno"].ToString(); } if (dt.Rows[n]["cardid"] != null && dt.Rows[n]["cardid"].ToString() != "") { model.cardid = dt.Rows[n]["cardid"].ToString(); } if (dt.Rows[n]["score"] != null && dt.Rows[n]["score"].ToString() != "") { model.score = dt.Rows[n]["score"].ToString(); } if (dt.Rows[n]["luquxueyuan"] != null && dt.Rows[n]["luquxueyuan"].ToString() != "") { model.luquxueyuan = dt.Rows[n]["luquxueyuan"].ToString(); } if (dt.Rows[n]["luquzhuanye"] != null && dt.Rows[n]["luquzhuanye"].ToString() != "") { model.luquzhuanye = dt.Rows[n]["luquzhuanye"].ToString(); } if (dt.Rows[n]["kstype"] != null && dt.Rows[n]["kstype"].ToString() != "") { model.kstype = dt.Rows[n]["kstype"].ToString(); } modelList.Add(model); } } return(modelList); }
public static string GetStr(string str) { zs.BLL.Tbl_Chaxun bll = new zs.BLL.Tbl_Chaxun(); if (bll.Exists(str)) { zs.Model.Tbl_Chaxun model = bll.GetModel(str); StringBuilder sb = new StringBuilder(); sb.Append("<strong>恭喜您被录取了,以下是您的录取信息,请核对:</strong>"); sb.Append("<ul>"); sb.Append("<li>姓名:" + model.name + "</li>"); sb.Append("<li>学号:" + model.stuno + "</li>"); sb.Append("<li>分数:" + model.score + "</li>"); sb.Append("<li>学院:" + model.luquxueyuan + "</li>"); sb.Append("<li>专业:" + model.luquzhuanye + "</li>"); sb.Append("</ul>"); return(sb.ToString()); } else { return("<strong>非常抱歉,没有" + str + "相应的录取信息,请您核对输入是否正确,或联系我们核实。</strong>"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zs.Model.Tbl_Chaxun model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zs.Model.Tbl_Chaxun model) { return(dal.Add(model)); }