/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { #region 验证 if (string.IsNullOrEmpty(tbCode.Text.Trim())) { Common.JShelper.JSAlert(this.Page, "", "教师编号不能为空!"); tbCode.Focus(); } else if (string.IsNullOrEmpty(tbName.Text.Trim())) { Common.JShelper.JSAlert(this.Page, "", "老师名称不能为空!"); tbName.Focus(); } else if (string.IsNullOrEmpty(tbPassword.Text.Trim())) { Common.JShelper.JSAlert(this.Page,"","密码不能为空!"); tbPassword.Focus(); } #endregion else { LabMS.Model.Teacher MT = new LabMS.Model.Teacher(); MT.CardCode = tbkpCode.Text.Trim(); MT.ComeFrom = tbcs.Text.Trim(); MT.Dirthday = DateTime.Parse(tbcsrq.Text.Trim()); MT.Education = tbwhcd.Text.Trim(); MT.Email = tbEmail.Text.Trim(); MT.Fax = tbFax.Text.Trim(); MT.GDate = DateTime.Parse(tbbysj.Text.Trim()); MT.GSchool = tbbyxx.Text.Trim(); MT.Health = tbjkzk.Text.Trim(); MT.HomeAddress = tbhomeAdd.Text.Trim(); MT.Homephone = tbhomeTel.Text.Trim(); MT.Jobs = tbzw.Text.Trim(); MT.Marriage = tbhyzk.Text.Trim(); MT.Mobile = tbPhone.Text.Trim(); MT.Nation = tbmz.Text.Trim(); MT.OfficeAddress = tbOfficeAdd.Text.Trim(); MT.Political = tbzzmm.Text.Trim(); MT.Professional = tbjszc.Text.Trim(); MT.Province = tbPro.Text.Trim(); MT.SexCode = ddlSex.SelectedValue.ToString(); MT.Specially = tbzyjstc.Text.Trim(); MT.Teacher_Code = tbCode.Text.Trim(); MT.Teacher_Name = tbName.Text.Trim(); MT.Tel = tbOfficeTel.Text.Trim(); MT.WorkDate = DateTime.Parse(tbgzrq.Text.Trim()); MT.Password = tbPassword.Text.Trim(); LabMS.BLL.Teacher BT = new LabMS.BLL.Teacher(); int a = BT.Add(MT); if (a > 0) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('新增成功!');window.opener.location.href=window.opener.location.href;self.close();</script>"); } } }
/* /// <summary> /// ��ҳ��ȡ�����б� /// </summary> public DataSet GetList(int PageSize,int PageIndex,string strWhere) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar,1000), }; parameters[0].Value = "Teacher"; parameters[1].Value = "ID"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }*/ /// <summary> /// ��¼��֤ /// </summary> /// <param name="strPeople"></param> /// <param name="strPass"></param> /// <returns></returns> public override object ValidatePeople(string strPeople, string strPass) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Teacher"); strSql.Append(" where Teacher_Name=@Teacher_Name and Password=@Password "); SqlParameter[] parameters = { new SqlParameter("@Teacher_Name", SqlDbType.VarChar,50), new SqlParameter("@Password", SqlDbType.VarChar,50)}; parameters[0].Value = strPeople; parameters[1].Value = strPass; DataSet ds = new DataSet(); try { ds = DbHelperSQL.Query(strSql.ToString(), parameters); } catch { throw (new Exception("���ݿ���ʴ���!")); } LabMS.Model.Teacher model = new LabMS.Model.Teacher(); try { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.Teacher_Code = ds.Tables[0].Rows[0]["Teacher_Code"].ToString(); model.Teacher_Name = ds.Tables[0].Rows[0]["Teacher_Name"].ToString(); model.SexCode = ds.Tables[0].Rows[0]["SexCode"].ToString(); if (ds.Tables[0].Rows[0]["Dirthday"].ToString() != "") { model.Dirthday = DateTime.Parse(ds.Tables[0].Rows[0]["Dirthday"].ToString()); } if (ds.Tables[0].Rows[0]["WorkDate"].ToString() != "") { model.WorkDate = DateTime.Parse(ds.Tables[0].Rows[0]["WorkDate"].ToString()); } model.Professional = ds.Tables[0].Rows[0]["Professional"].ToString(); if (ds.Tables[0].Rows[0]["GDate"].ToString() != "") { model.GDate = DateTime.Parse(ds.Tables[0].Rows[0]["GDate"].ToString()); } model.GSchool = ds.Tables[0].Rows[0]["GSchool"].ToString(); model.Specially = ds.Tables[0].Rows[0]["Specially"].ToString(); model.Education = ds.Tables[0].Rows[0]["Education"].ToString(); model.Jobs = ds.Tables[0].Rows[0]["Jobs"].ToString(); model.Nation = ds.Tables[0].Rows[0]["Nation"].ToString(); model.Province = ds.Tables[0].Rows[0]["Province"].ToString(); model.CardCode = ds.Tables[0].Rows[0]["CardCode"].ToString(); model.ComeFrom = ds.Tables[0].Rows[0]["ComeFrom"].ToString(); model.Political = ds.Tables[0].Rows[0]["Political"].ToString(); model.Health = ds.Tables[0].Rows[0]["Health"].ToString(); model.Marriage = ds.Tables[0].Rows[0]["Marriage"].ToString(); model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); model.OfficeAddress = ds.Tables[0].Rows[0]["OfficeAddress"].ToString(); model.Homephone = ds.Tables[0].Rows[0]["Homephone"].ToString(); model.HomeAddress = ds.Tables[0].Rows[0]["HomeAddress"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString(); model.Password = ds.Tables[0].Rows[0]["Password"].ToString(); return model; } else { return null; } } catch { throw (new Exception("datasetTOobjectת������!")); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.Teacher GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,Teacher_Code,Teacher_Name,SexCode,Dirthday,WorkDate,Professional,GDate,GSchool,Specially,Education,Jobs,Nation,Province,CardCode,ComeFrom,Political,Health,Marriage,Tel,OfficeAddress,Homephone,HomeAddress,Mobile,Email,Fax,Password from Teacher "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.Teacher model=new LabMS.Model.Teacher(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.Teacher_Code=ds.Tables[0].Rows[0]["Teacher_Code"].ToString(); model.Teacher_Name=ds.Tables[0].Rows[0]["Teacher_Name"].ToString(); model.SexCode=ds.Tables[0].Rows[0]["SexCode"].ToString(); if(ds.Tables[0].Rows[0]["Dirthday"].ToString()!="") { model.Dirthday=DateTime.Parse(ds.Tables[0].Rows[0]["Dirthday"].ToString()); } if(ds.Tables[0].Rows[0]["WorkDate"].ToString()!="") { model.WorkDate=DateTime.Parse(ds.Tables[0].Rows[0]["WorkDate"].ToString()); } model.Professional=ds.Tables[0].Rows[0]["Professional"].ToString(); if(ds.Tables[0].Rows[0]["GDate"].ToString()!="") { model.GDate=DateTime.Parse(ds.Tables[0].Rows[0]["GDate"].ToString()); } model.GSchool=ds.Tables[0].Rows[0]["GSchool"].ToString(); model.Specially=ds.Tables[0].Rows[0]["Specially"].ToString(); model.Education=ds.Tables[0].Rows[0]["Education"].ToString(); model.Jobs=ds.Tables[0].Rows[0]["Jobs"].ToString(); model.Nation=ds.Tables[0].Rows[0]["Nation"].ToString(); model.Province=ds.Tables[0].Rows[0]["Province"].ToString(); model.CardCode=ds.Tables[0].Rows[0]["CardCode"].ToString(); model.ComeFrom=ds.Tables[0].Rows[0]["ComeFrom"].ToString(); model.Political=ds.Tables[0].Rows[0]["Political"].ToString(); model.Health=ds.Tables[0].Rows[0]["Health"].ToString(); model.Marriage=ds.Tables[0].Rows[0]["Marriage"].ToString(); model.Tel=ds.Tables[0].Rows[0]["Tel"].ToString(); model.OfficeAddress=ds.Tables[0].Rows[0]["OfficeAddress"].ToString(); model.Homephone=ds.Tables[0].Rows[0]["Homephone"].ToString(); model.HomeAddress=ds.Tables[0].Rows[0]["HomeAddress"].ToString(); model.Mobile=ds.Tables[0].Rows[0]["Mobile"].ToString(); model.Email=ds.Tables[0].Rows[0]["Email"].ToString(); model.Fax=ds.Tables[0].Rows[0]["Fax"].ToString(); model.Password = ds.Tables[0].Rows[0]["Password"].ToString(); return model; } else { return null; } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { #region 验证 if (string.IsNullOrEmpty(tbCode.Text.Trim())) { Common.JShelper.JSAlert(this.Page, "", "教师编号不能为空!"); tbCode.Focus(); } else if (string.IsNullOrEmpty(tbName.Text.Trim())) { Common.JShelper.JSAlert(this.Page, "", "老师名称不能为空!"); tbName.Focus(); } else if (string.IsNullOrEmpty(tbPassword.Text.Trim())) { Common.JShelper.JSAlert(this.Page, "", "密码不能为空!"); tbPassword.Focus(); } #endregion else { LabMS.Model.Teacher MT = new LabMS.Model.Teacher(); MT.CardCode = tbkpCode.Text.Trim(); MT.ComeFrom = tbcs.Text.Trim(); if (tbcsrq.Text.Trim() != "") { MT.Dirthday = DateTime.Parse(tbcsrq.Text.Trim()); } MT.Education = tbwhcd.Text.Trim(); MT.Email = tbEmail.Text.Trim(); MT.Fax = tbFax.Text.Trim(); if (tbbysj.Text.Trim() != "") { MT.GDate = DateTime.Parse(tbbysj.Text.Trim()); } MT.GSchool = tbbyxx.Text.Trim(); MT.Health = tbjkzk.Text.Trim(); MT.HomeAddress = tbhomeAdd.Text.Trim(); MT.Homephone = tbhomeTel.Text.Trim(); MT.Jobs = tbzw.Text.Trim(); MT.Marriage = tbhyzk.Text.Trim(); MT.Mobile = tbPhone.Text.Trim(); MT.Nation = tbmz.Text.Trim(); MT.OfficeAddress = tbOfficeAdd.Text.Trim(); MT.Political = tbzzmm.Text.Trim(); MT.Professional = tbjszc.Text.Trim(); MT.Province = tbPro.Text.Trim(); MT.SexCode = ddlSex.SelectedValue.ToString(); MT.Specially = tbzyjstc.Text.Trim(); MT.Teacher_Code = tbCode.Text.Trim(); MT.Teacher_Name = tbName.Text.Trim(); MT.Tel = tbOfficeTel.Text.Trim(); MT.Password = tbPassword.Text.Trim(); if (tbgzrq.Text.Trim() != "") { MT.WorkDate = DateTime.Parse(tbgzrq.Text.Trim()); } MT.ID = int.Parse(Request.QueryString["ID"].ToString()); LabMS.BLL.Teacher BT = new LabMS.BLL.Teacher(); try { BT.Update(MT); if (FlagHF.Value == "look") { Common.JShelper.JsAlertAndClose(Page, "", "修改成功!"); } else { Common.JShelper.JSAlertAndRedirect(this.Page, "", "修改成功!", "BaseDataTeacherList.aspx"); } } catch { Common.JShelper.JSAlert(this.Page, "", "修改失败!"); } } }
protected void Save_OnClick(object sender, EventArgs e) { #region if (String.IsNullOrEmpty(UserPasswordTBX.Text.Trim())) { Common.JShelper.JSAlert(Page, "script", "请输入旧密码!"); return; } if (UserPasswordTBX.Text.Length > 50) { Common.JShelper.JSAlert(Page, "script", "旧密码长度输入过长!"); return; } if (String.IsNullOrEmpty(NewPasswordTBX.Text.Trim())) { Common.JShelper.JSAlert(Page, "script", "请输入新密码密码!"); return; } if (NewPasswordTBX.Text.Length > 50) { Common.JShelper.JSAlert(Page, "script", "新密码长度输入过长!"); return; } if (!Regex.IsMatch(NewPasswordTBX.Text.Trim(), @"^\w+$")) { Common.JShelper.JSAlert(Page, "script", "新密码输入不合法(只能为数字、英文或下划线的组合)!"); return; } //if (String.IsNullOrEmpty(RePasswordTBX.Text.Trim())) //{ // Common.JShelper.JSAlert(Page, "script", "请重复输入新密码!"); //} //if (RePasswordTBX.Text.Length > 50) //{ // Common.JShelper.JSAlert(Page, "script", "重复新密码长度输入过长!"); //} //if (!Regex.IsMatch(RePasswordTBX.Text.Trim(), @"^\w+$")) //{ // Common.JShelper.JSAlert(Page, "script", "重复新密码输入不合法(只能为数字、英文或下划线的组合)!"); //} if (String.Compare(RePasswordTBX.Text, NewPasswordTBX.Text) != 0) { Common.JShelper.JSAlert(Page, "script", "两次新密码输入不一致!"); return; } //验证用户名和密码输入是否正确 if (!IsUserNameAndPassword()) { Common.JShelper.JSAlert(Page, "script", "用户名和密码输入不匹配!"); return; } #endregion if (!String.IsNullOrEmpty(UserID)) { int ID; if (int.TryParse(UserID, out ID)) { if (UserType == "mana") { LabMS.BLL.UserTable userTable = new LabMS.BLL.UserTable(); LabMS.Model.UserTable userTableModel = new LabMS.Model.UserTable(); userTableModel = userTable.GetModel(ID); userTableModel.Password = NewPasswordTBX.Text.Trim(); try { userTable.Update(userTableModel); Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功!"); } catch { Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!"); } } else if (UserType == "teacher") { LabMS.BLL.Teacher userTable = new LabMS.BLL.Teacher(); LabMS.Model.Teacher userTableModel = new LabMS.Model.Teacher(); userTableModel = userTable.GetModel(ID); userTableModel.Password = NewPasswordTBX.Text.Trim(); try { userTable.Update(userTableModel); Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功!"); } catch { Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!"); } } else { LabMS.BLL.Student userTable = new LabMS.BLL.Student(); LabMS.Model.Student userTableModel = new LabMS.Model.Student(); userTableModel = userTable.GetModel(ID); userTableModel.Student_Pass = NewPasswordTBX.Text.Trim(); try { userTable.Update(userTableModel); Common.JShelper.JsAlertAndClose(Page, "script", "密码修改成功!"); } catch { Common.JShelper.JsAlertAndClose(Page, "script", "密码修改失败!"); } } } else { Common.JShelper.JsAlertAndClose(Page, "script", "用户ID存储不合法,请退出系统,重新登录后进行修改密码!"); } } else { Common.JShelper.JsAlertAndClose(Page, "script", "用户Session丢失,请退出系统,重新登录后进行修改密码!"); } }