//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.MechanicalEntity model = new Entity.MechanicalEntity(); Daiv_OA.BLL.ContactBLL contactBll = new Daiv_OA.BLL.ContactBLL(); Daiv_OA.BLL.MechanicalBLL mechanicalBll = new Daiv_OA.BLL.MechanicalBLL(); if (Request["schClassgcid"] == null || string.IsNullOrEmpty(Request["schClassgcid"].ToString())) { FinalMessage("班级无效!", "Mechanical_Edit.aspx?id=" + q("id"), 0); return; } model = mechanicalBll.GetEntity(Str2Int(q("id"), 0)); model.ClassName = ""; model.Gid = int.Parse(Request["schClassgcid"]); model.MechIMEI = this.MechIMEI.Text; model.MechName = this.MechName.Text; model.MechPhone = this.MechPhone.Text; //检查是否已经存在的班级 Entity.MechanicalEntity tempEntity = mechanicalBll.GetEntityByImeiAndGid(model.MechIMEI, model.Gid); if (tempEntity != null && tempEntity.ID != model.ID) { FinalMessage("此班级已经存在此设置号,请使用其他的设备号!", "Mechanical_Edit.aspx?id=" + q("id"), 0); return; } mechanicalBll.Update(model); logHelper.logInfo("修改设备成功!操作人:" + UserId); FinalMessage("操作成功", "Mechanical_List.aspx", 0); }
//数据绑定 void Bind() { int gid = Str2Int(q("id"), 0); Daiv_OA.Entity.StudentEntity model = new Daiv_OA.Entity.StudentEntity(); model = new Daiv_OA.BLL.StudentBLL().GetEntity(gid); this.Snumber.Text = model.Snumber; this.Sname.Text = model.Sname; this.Sbirthday.Text = model.Sbirthday.ToString("yyyy-MM-dd"); //绑定家长联系电话 List <Daiv_OA.Entity.ContactEntity> cModels = new Daiv_OA.BLL.ContactBLL().GetEntitysBySid(model.Sid); StringBuilder sbuilder = new StringBuilder(); sbuilder.AppendLine("<table id = \"contactTable\" class=\"ipt\" width=\"280px;\" >"); sbuilder.AppendLine("<thead><tr><td>名称</td><td>电话号码</td><td>操作<input type=\"button\" id =\"contactAdd\" value =\"添加\" /></td></tr></thead>"); int index = 0; if (cModels != null && cModels.Count > 0) { foreach (var item in cModels) { sbuilder.AppendLine("<tr class=\"contactTr\">"); sbuilder.AppendLine("<td><input type = \"text\" name =\"contactName\" value =\"" + item.CPhoneName + "\" maxlength=\"32\" onkeyup =\"value = value.replace(/[^\\a-\\z\\-\\Z0-9\\u4E00-\\u9FA5]/g, '')\" onpaste =\"return false\" oncontextmenu =\"return false; \" /></td>"); sbuilder.AppendLine("<td ><input type = \"text\" name =\"contactPhone\" value =\"" + item.Cphone + "\" style =\"width:120px;\" onkeyup=\"value = value.replace(/[^0-9]/g,'')\" onpaste=\"return false\" oncontextmenu=\"return false; \" /></td>"); sbuilder.AppendLine("<td><input type = \"button\" class=\"contactDelete\" value =\"删除\" style =\"" + (index == 0? "display:none;" : "") + "\" /></td>"); sbuilder.AppendLine("</tr>"); index++; } } else { sbuilder.AppendLine("<tr class=\"contactTr\">"); sbuilder.AppendLine("<td><input type = \"text\" name =\"contactName\" value =\"\" style =\"width:60px;\" /></td>"); sbuilder.AppendLine("<td ><input type = \"text\" name =\"contactPhone\" value =\"\" style =\"width:120px;\" /></td>"); sbuilder.AppendLine("<td><input type = \"button\" class=\"contactDelete\" value =\"删除\" style =\"display:none;\" /></td>"); sbuilder.AppendLine("</tr>"); } sbuilder.AppendLine("</table>"); this.ltMasterSetting.Text = sbuilder.ToString(); //设置班级 SchClassId = model.Gid; //设置年级 Entity.GradeEntity cmodel = new BLL.GradeBLL().GetEntity(SchClassId); Entity.SchoolGradeEntity gmodel = null; if (cmodel != null) { SchGradeId = cmodel.GgradeID; //获取学校对象 gmodel = new BLL.SchoolGradeBLL().GetEntity(SchGradeId); } //设置学校 if (gmodel != null) { SchID = gmodel.SchoolID; } }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.SchoolGradeEntity model = new Entity.SchoolGradeEntity(); Daiv_OA.BLL.ContactBLL contactBll = new Daiv_OA.BLL.ContactBLL(); Daiv_OA.BLL.SchoolGradeBLL SchoolGradeBll = new Daiv_OA.BLL.SchoolGradeBLL(); model = SchoolGradeBll.GetEntity(Str2Int(q("id"), 0)); model.SchoolID = int.Parse(this.ddlGid.SelectedValue); model.Name = this.Name.Text; Entity.SchoolGradeEntity sgEntity = SchoolGradeBll.GetEntityByNameAndScId(model.Name, model.SchoolID); if (sgEntity != null && sgEntity.ID != model.ID) { FinalMessage("已经存在:此学校的班级:" + model.Name, "SchoolGrade_Edit.aspx?id=" + model.ID + "&shid=" + schId, 0); return; } SchoolGradeBll.Update(model); logHelper.logInfo("修改设备成功!操作人:" + UserId); FinalMessage("操作成功", "SchoolGrade_List.aspx?shid=" + schId, 0); }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.SchoolEntity model = new Entity.SchoolEntity(); Daiv_OA.BLL.ContactBLL contactBll = new Daiv_OA.BLL.ContactBLL(); Daiv_OA.BLL.SchoolBLL SchoolBll = new Daiv_OA.BLL.SchoolBLL(); model = SchoolBll.GetEntity(Str2Int(q("id"), 0)); model.Name = this.Name.Text; model.Address = this.Address.Text; model.SchoolSerie = this.SchoolSerie.Text; //判断该名称是否存在 Entity.SchoolEntity stemp = SchoolBll.GetEntityByName(model.Name); if (stemp != null && stemp.ID != model.ID) { FinalMessage("学校名称:" + model.Name + "已存在!", "School_Eidt.aspx?id=" + model.ID, 1); return; } SchoolBll.Update(model); logHelper.logInfo("修改学校成功!操作人:" + UserId); FinalMessage("操作成功", "School_List.aspx", 0); }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.StudentEntity model = new Entity.StudentEntity(); Daiv_OA.BLL.ContactBLL contactBll = new Daiv_OA.BLL.ContactBLL(); Daiv_OA.BLL.StudentBLL studentBll = new Daiv_OA.BLL.StudentBLL(); Daiv_OA.BLL.GradeBLL gradeBll = new BLL.GradeBLL(); string uuid = Guid.NewGuid().ToString("N"); //修改联系电话 //保存上传文件 string fName = UploadFile(uuid); string path = Path.Combine(Server.MapPath("/"), "upload/" + DateTime.Now.ToString("yyyy/MM").Replace("/", "").Substring(0, 6)); ImportExcel import = new ImportExcel(); import.LoadFile(path + "/" + fName); DataSet ds = import.GetAllTables(true); DataTable dataTable = ds.Tables[0]; //获取班级数据 List <Entity.GradeEntity> glist = gradeBll.GetModelList(""); if (glist == null || glist.Count <= 0) { logHelper.logInfo("未添加任何班级数据!"); FinalMessage("导入失败,请先添加班级数据!", "", 0); } #region 验证表格 //验证表格 if (dataTable.Rows.Count <= 0) { logHelper.logInfo(fName + ",未填写任何学生数据!"); FinalMessage(fName + ",未填写任何学生数据!", "", 0); return; } for (int i = 0; i < colmun.Length; i++) { if (colmun[i] != dataTable.Columns[i].ColumnName) { FinalMessage("导入的excel表与模板excel表不符合!", "", 0); message.Visible = true; return; } } //验证班级数据 int tbCount = dataTable.Rows.Count; string tempCName = string.Empty; if (Request["schClassgcid"] == null || string.IsNullOrEmpty(Request["schClassgcid"].ToString())) { FinalMessage("没有选择班级,请重新选择!", "", 0); return; } try { SchClassId = int.Parse(Request["schClassgcid"].ToString()); } catch (Exception ex) { FinalMessage("班级转换失败,请重新选择!", "", 0); return; } //for (int j = 0; j < tbCount; j++) //{ // tempCName = Convert.ToString(dataTable.Rows[j][colmun[2]]); // if (glist.Where(g=>g.Gname == tempCName).FirstOrDefault() == null) // { // logHelper.logInfo(tempCName + " 未匹配到此班级名称!"); // FinalMessage(tempCName + " 未匹配到此班级名称!", "", 0); // message.Visible = true; // return; // } //} //验证时间的有效性 for (int i = 0; i < tbCount; i++) { try { Convert.ToDateTime(dataTable.Rows[i][colmun[3]]); } catch (Exception) { logHelper.logInfo(string.Format("'{0}' 出生年月日无效!", tempCName)); FinalMessage(Convert.ToString(dataTable.Rows[i][colmun[1]]) + "学生出生时间无效!", "", 0); message.Visible = true; return; } //验证学号 //验证学生序号是否存在 string snumbertemp = Convert.ToString(dataTable.Rows[i][colmun[0]]); bool exixt = new Daiv_OA.BLL.StudentBLL().Exists(snumbertemp); Daiv_OA.BLL.ContactBLL ctBll = new Daiv_OA.BLL.ContactBLL(); if (exixt) { FinalMessage(snumbertemp + "相同的学生学号已经存在", "", 0); message.Visible = true; return; } } #endregion //遍历表格 Entity.StudentEntity studentEntity = null; Entity.UserEntity parent = null; Entity.ContactEntity contactEnitty = null; for (int i = 0; i < tbCount; i++) { studentEntity = new Entity.StudentEntity(); parent = new Entity.UserEntity(); contactEnitty = new Entity.ContactEntity(); //保存数据 try { //学生实体相关信息保存 studentEntity.Gname = glist.Where(g => g.Gid == SchClassId).FirstOrDefault().Gname; //班级名称 列索引:2 studentEntity.Gid = glist.Where(g => g.Gid == SchClassId).FirstOrDefault().Gid; studentEntity.Snumber = Convert.ToString(dataTable.Rows[i][colmun[0]]); //学生学号 列索引:0 studentEntity.Sname = Convert.ToString(dataTable.Rows[i][colmun[1]]); //学生名称 列索引:1 studentEntity.Sbirthday = Convert.ToDateTime(dataTable.Rows[i][colmun[3]]); //出生年月日 列索引:3 //家长实体相关信息保存 parent.Uname = studentEntity.Snumber; string pwd = studentEntity.Sbirthday.ToString("yy") + studentEntity.Sbirthday.ToString("MM") + studentEntity.Sbirthday.ToString("dd"); parent.Upwd = Daiv_OA.Utils.MD5.Lower32(pwd); parent.Pid = 4; parent.Did = 0; parent.Position = "家长"; parent.Mphone = ""; Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(parent.Pid); parent.Setting = powerEntity.Setting; //联系电话实体相关信息保存 contactEnitty.Cphone = Convert.ToString(dataTable.Rows[i][colmun[4]]); //家长联系电话1 列索引:4 contactEnitty.Cphone2 = Convert.ToString(dataTable.Rows[i][colmun[5]]); //家长联系电话2 列索引:5 contactEnitty.Cphone3 = Convert.ToString(dataTable.Rows[i][colmun[6]]); //家长联系电话3 列索引:6 contactEnitty.Cphone4 = Convert.ToString(dataTable.Rows[i][colmun[7]]); //家长联系电话4 列索引:7 List <Entity.ContactEntity> contactList = new List <Entity.ContactEntity>(); contactList.Add(new Entity.ContactEntity() { CPhoneName = "家长1", Cphone = contactEnitty.Cphone }); contactList.Add(new Entity.ContactEntity() { CPhoneName = "家长2", Cphone = contactEnitty.Cphone2 }); contactList.Add(new Entity.ContactEntity() { CPhoneName = "家长3", Cphone = contactEnitty.Cphone3 }); contactList.Add(new Entity.ContactEntity() { CPhoneName = "家长4", Cphone = contactEnitty.Cphone4 }); //当前操作人对象 Entity.UserEntity opera = new Daiv_OA.BLL.UserBLL().GetEntity(UserId); new Daiv_OA.BLL.StudentBLL().Add(studentEntity, parent, contactList, opera); } catch (Exception ex) { FinalMessage("操作失败!" + ex.Message, "Student_List.aspx", 1); return; } // FinalMessage("操作成功", "Student_List.aspx", 0); } logHelper.logInfo("导入成功!操作人:" + UserId); FinalMessage("导入成功", "Student_List.aspx", 0); }
/// <summary> /// 添加数据 /// </summary> /// <param name="studentEntity"></param> /// <param name="parent"></param> /// <param name="contactEnitty"></param> /// <param name="operatModel"></param> /// <returns></returns> public int Add(Entity.StudentEntity studentEntity, Entity.UserEntity parent, List <Entity.ContactEntity> contactList, Entity.UserEntity operatModel) { //验证学生序号是否存在 bool exixt = new Daiv_OA.BLL.StudentBLL().Exists(studentEntity.Snumber); Daiv_OA.BLL.ContactBLL ctBll = new Daiv_OA.BLL.ContactBLL(); if (exixt) { throw new Exception("相同的学生学号已经存在"); } int pId = 0; int sid = 0; try { //验证电话号码 foreach (var item in contactList) { if (!string.IsNullOrEmpty(item.Cphone) && !Validator.IsMobileNum(item.Cphone)) { throw new Exception(item.Cphone + "电话号码无效!"); } } //添加家长信息 pId = new Daiv_OA.BLL.UserBLL().Add(parent); if (pId > 0) { studentEntity.Uid = pId; //添加设置人员 studentEntity.MechID = operatModel.Uid; } else { throw new Exception("添加家长账号失败,请重新添加!"); } sid = new Daiv_OA.BLL.StudentBLL().Add(studentEntity); if (sid > 0) { //删除情亲好 ctBll.DeleteBySid(sid); //联系电话实体添加 foreach (var item in contactList) { item.Sid = sid; new Daiv_OA.BLL.ContactBLL().Add(item); } } else if (sid == 0) { throw new Exception("相同的学生已经存在"); } else if (sid == -1) { throw new Exception("相同的年级已经存在"); } } catch (Exception ex) { if (pId > 0) { new Daiv_OA.BLL.UserBLL().Delete(pId); } if (sid > 0) { Delete(sid); } logHelper.logInfo("添加学生失败!操作员ID:" + operatModel.Uname + " 失败原因:" + ex.Message); throw ex; } return(1); }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.StudentEntity model = new Entity.StudentEntity(); Daiv_OA.BLL.ContactBLL contactBll = new Daiv_OA.BLL.ContactBLL(); Daiv_OA.BLL.StudentBLL studentBll = new Daiv_OA.BLL.StudentBLL(); if (Request["schClassgcid"] == null || string.IsNullOrEmpty(Request["schClassgcid"].ToString())) { FinalMessage("班级无效!", "Student_Edit.aspx?id=" + q("id") + "&cid=" + classId, 0); return; } model = studentBll.GetEntity(Str2Int(q("id"), 0)); model.Gname = ""; model.Gid = int.Parse(Request["schClassgcid"]); model.Sname = this.Sname.Text; model.Sbirthday = Convert.ToDateTime(this.Sbirthday.Text); List <Entity.ContactEntity> contactList = new List <Entity.ContactEntity>(); string[] contactpArr = Request.Form["contactPhone"].Split(','); string[] contactnArr = Request.Form["contactName"].Split(','); //检查电话号码 for (int i = 0; i < contactpArr.Length; i++) { if (string.IsNullOrEmpty(contactpArr[i]) || string.IsNullOrEmpty(contactnArr[i])) { continue; } if (!string.IsNullOrEmpty(contactpArr[i]) && !Validator.IsMobileNum(contactpArr[i])) { FinalMessage(contactpArr[i] + "电话号码无效!", "Student_Edit.aspx?id=" + q("id") + "&cid=" + classId, 0); return; } contactList.Add(new Entity.ContactEntity() { Cphone = contactpArr[i], CPhoneName = contactnArr[i] }); } //检查电话号码 //if (!string.IsNullOrEmpty(Cphone.Text) && !Validator.IsMobileNum(Cphone.Text)) { // FinalMessage(Cphone.Text + "电话号码无效!", "Student_Edit.aspx?id="+ q("id"), 0); // return; //} //if (!string.IsNullOrEmpty(Cphone2.Text) && !Validator.IsMobileNum(Cphone2.Text)) { // FinalMessage(Cphone2.Text + "电话号码无效!", "Student_Edit.aspx?id=" + q("id"), 0); // return; //} //if (!string.IsNullOrEmpty(Cphone3.Text) && !Validator.IsMobileNum(Cphone3.Text)) { // FinalMessage(Cphone3.Text + "电话号码无效!", "Student_Edit.aspx?id=" + q("id"), 0); // return; //} //if (!string.IsNullOrEmpty(Cphone4.Text) && !Validator.IsMobileNum(Cphone4.Text)) //{ // FinalMessage(Cphone4.Text + "电话号码无效!", "Student_Edit.aspx?id=" + q("id"), 0); // return; //} studentBll.Update(model); //修改联系电话 //Entity.ContactEntity cModel = contactBll.GetEntityBySid(model.Sid); //cModel.Cphone = this.Cphone.Text; //cModel.Cphone2 = this.Cphone2.Text; //cModel.Cphone3 = this.Cphone3.Text; //cModel.Cphone4 = this.Cphone4.Text; //contactBll.Update(cModel); //获取情亲号数据 //删除数据 //contactBll.DeleteBySid(model.Sid); ////联系电话实体添加 //foreach (var item in contactList) //{ // item.Sid = model.Sid; // contactBll.Add(item); //} //contactBll.AddBatch(contactList, model.Sid); logHelper.logInfo("修改班级成功!操作人:" + UserId); FinalMessage("操作成功", "Student_List.aspx?cid=" + classId, 0); }