private void ChangePass_Load(object sender, EventArgs e) { CurEmp = GetUserModel(SessionConfig.UserID); if (CurEmp != null) { //this.textBox1.Text = CurEmp.Emp_LoginPwd; } }
public Employee(Bll_Bse_Employee employeeInstance, Bll_Dept deptInstance, Bse_Employee _EmplyeeModel) { InitializeComponent(); DeptInstance = deptInstance; EmployeeInstance = employeeInstance; EmplyeeModel = _EmplyeeModel; this.Load+=new EventHandler(Employee_Load); }
/// <summary> /// 生成员工编码 /// </summary> /// <returns></returns> //public string GenerateEmpCode() //{ // var val = new Bll_Comm().GetMax("Bse_Employee", "Emp_ID"); // int re=Common.C_Class.Utils.TypeConverter.ObjectToInt(val)+1; // return re.ToString(); //} /// <summary> /// '获取实体 /// </summary> /// <param name="condition"></param> /// <returns></returns> public Bse_Employee GetModel(string condition) { List<Bse_Employee> list = instance.GetListByWhere(condition); Bse_Employee model = new Bse_Employee(); if (list != null && list.Count > 0) { model = list[0]; } return model; }
public bool DeleteEmployee(Bse_Employee model) { bool result = false; model.Stat = 1; int _result = instance.Update(model); if (_result > 0) { result = true; } return result; }
public LoginResultEnum CheckLogin(string userName, string password, out Bse_Employee model) { LoginResultEnum re = LoginResultEnum.Fail; model = new Bse_Employee(); try { //判断用户名是否存在 model = GetUserModel(userName); if (model != null) { //if (model.Emp_CanLogin != "Yes") //{ // re = LoginResultEnum.NoExsist; //} //密码有效性验证 if (password.Equals(model.Emp_LoginPwd)) { re = LoginResultEnum.Success; } else { re = LoginResultEnum.InValidPwd; } } else { re = LoginResultEnum.NoExsist; } } catch (Exception e) { //Alert.Show(e.Message); re = LoginResultEnum.Fail; } //权限 return re; }
//登陆 public ActionResult LoginBtn() { //TODO:corporation string result = "fail"; string msg = string.Empty; string company = Request["company"]; string userName = Request["userName"]; string userPwd = Request["pwd"]; //string userRole = Request["role"]; //string result = ""; if (!Net.CheckConn()) { return Json(new { result = result, msg = "无法连接到服务器!请检查网络情况。" }); } try { if (userName == null || userPwd == null) { result = "fail"; msg = "用户名或密码不能为空"; //return Content("Null"); } else { Session.RemoveAll(); Session.Clear(); //TODO:1.4 //得到公司 // string pwd = Md5.MD5(userPwd.Replace('\'', '"')); string pwd = userPwd; //角色Stuff_LoginType and Stuff_LoginType='" + userRole + "' HR_Stuff = instanceHR_Stuff.GetModel(" and Emp_LoginID='" + userName.Replace('\'', '"') + "' and Emp_LoginPwd='" + pwd + "'"); if (HR_Stuff == null) { result = "fail"; msg = "用户名或密码不正确 "; } else { //用户名 this.SetSession<string>("UserName", HR_Stuff.Emp_Name); //员工编码 this.SetSession<string>("UserId", HR_Stuff.Emp_Code); //员工登录名 this.SetSession<string>("LoginName", HR_Stuff.Emp_LoginID); //登录IP this.SetSession<string>("IP", HttpContext.Request.UserHostAddress); //部门信息 Bse_Department =instanceDepartment.GetModel(" and Dept_Code='" + HR_Stuff.Emp_Dept_Code + "'"); if (Bse_Department != null) { //部门id this.SetSession<string>("DeptId", Bse_Department.Dept_Code.ToString()); //部门名称 this.SetSession<string>("DeptName", Bse_Department.Dept_Name); //用户角色//hack this.SetSession<string>("UserRole", ""); //DODO:hao //Bse_Department fagTemp = instanceBse_Department.GetModel(" and Dept_Code='" + Bse_Department.Dept_PCode.ToString() + "'"); //while (!string.IsNullOrEmpty(fagTemp.Dept_PCode)) //{ // fagTemp = instanceBse_Department.GetModel(" and Dept_Code='" + fagTemp.Dept_PCode + "'"); //} //string companyUser = fagTemp.Dept_Name.ToString(); ////公司编码 //string companyCode = fagTemp.Dept_Code.ToString(); ////this.SetSession<string>("Company", company); //this.SetSession<string>("CompanyCode", companyCode); //部门编码 // this.SetSession<string>("DeptCode", Bse_Department.Dept_Code); //TODO:得到公司问题 //companyCode=new BLL.Bll_Bse_Department().GetCompanyName("" + Bse_Department.Dept_Code + ""); //this.SetSession<string>("Company", companyUser); result ="success"; msg = ""; } else { result ="fail"; msg = "用户信息配置错误"; } } } } catch (System.Exception ex) { result = "fail"; // msg = "网络连接不通,请重试"; msg = ex.Message; // PlateLog.Write("连接异常:", PlateLog.LogMessageType.Error,ex); } //QX.Log.PlateLog.WriteOp //写入登录日志 Bll_Comm.LoginLog(userName,msg); return Json(new { result = result, msg = msg }); }
/// <summary> /// 更新Bse_Employee对象(即:一条记录 /// </summary> public int Update(Bse_Employee bse_Employee) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE Bse_Employee SET "); if(bse_Employee.Emp_Code_IsChanged){sbParameter.Append("Emp_Code=@Emp_Code, ");} if(bse_Employee.Emp_Name_IsChanged){sbParameter.Append("Emp_Name=@Emp_Name, ");} if(bse_Employee.Emp_Gendar_IsChanged){sbParameter.Append("Emp_Gendar=@Emp_Gendar, ");} if(bse_Employee.Emp_Dept_Code_IsChanged){sbParameter.Append("Emp_Dept_Code=@Emp_Dept_Code, ");} if(bse_Employee.Emp_Dept_Name_IsChanged){sbParameter.Append("Emp_Dept_Name=@Emp_Dept_Name, ");} if(bse_Employee.Emp_TitleName_IsChanged){sbParameter.Append("Emp_TitleName=@Emp_TitleName, ");} if(bse_Employee.Emp_Title_IsChanged){sbParameter.Append("Emp_Title=@Emp_Title, ");} if(bse_Employee.Emp_DutyName_IsChanged){sbParameter.Append("Emp_DutyName=@Emp_DutyName, ");} if(bse_Employee.Emp_Duty_IsChanged){sbParameter.Append("Emp_Duty=@Emp_Duty, ");} if(bse_Employee.Emp_Birth_IsChanged){sbParameter.Append("Emp_Birth=@Emp_Birth, ");} if(bse_Employee.Emp_StartDate_IsChanged){sbParameter.Append("Emp_StartDate=@Emp_StartDate, ");} if(bse_Employee.Emp_Bak_IsChanged){sbParameter.Append("Emp_Bak=@Emp_Bak, ");} if(bse_Employee.Emp_CanLogin_IsChanged){sbParameter.Append("Emp_CanLogin=@Emp_CanLogin, ");} if(bse_Employee.Emp_LoginID_IsChanged){sbParameter.Append("Emp_LoginID=@Emp_LoginID, ");} if(bse_Employee.Emp_LoginPwd_IsChanged){sbParameter.Append("Emp_LoginPwd=@Emp_LoginPwd, ");} if(bse_Employee.Emp_Mobile_IsChanged){sbParameter.Append("Emp_Mobile=@Emp_Mobile, ");} if(bse_Employee.Emp_HomeTel_IsChanged){sbParameter.Append("Emp_HomeTel=@Emp_HomeTel, ");} if(bse_Employee.Emp_OffTel_IsChanged){sbParameter.Append("Emp_OffTel=@Emp_OffTel, ");} if(bse_Employee.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(bse_Employee.Emp_Stat_IsChanged){sbParameter.Append("Emp_Stat=@Emp_Stat, ");} if(bse_Employee.Emp_Date_IsChanged){sbParameter.Append("Emp_Date=@Emp_Date, ");} if(bse_Employee.Emp_Order_IsChanged){sbParameter.Append("Emp_Order=@Emp_Order ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Emp_ID=@Emp_ID; " ); string sql=sb.ToString(); if(bse_Employee.Emp_Code_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Code)) { idb.AddParameter("@Emp_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Code", bse_Employee.Emp_Code); } } if(bse_Employee.Emp_Name_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Name)) { idb.AddParameter("@Emp_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Name", bse_Employee.Emp_Name); } } if(bse_Employee.Emp_Gendar_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Gendar)) { idb.AddParameter("@Emp_Gendar", DBNull.Value); } else { idb.AddParameter("@Emp_Gendar", bse_Employee.Emp_Gendar); } } if(bse_Employee.Emp_Dept_Code_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Code)) { idb.AddParameter("@Emp_Dept_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Code", bse_Employee.Emp_Dept_Code); } } if(bse_Employee.Emp_Dept_Name_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Name)) { idb.AddParameter("@Emp_Dept_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Name", bse_Employee.Emp_Dept_Name); } } if(bse_Employee.Emp_TitleName_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_TitleName)) { idb.AddParameter("@Emp_TitleName", DBNull.Value); } else { idb.AddParameter("@Emp_TitleName", bse_Employee.Emp_TitleName); } } if(bse_Employee.Emp_Title_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Title)) { idb.AddParameter("@Emp_Title", DBNull.Value); } else { idb.AddParameter("@Emp_Title", bse_Employee.Emp_Title); } } if(bse_Employee.Emp_DutyName_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_DutyName)) { idb.AddParameter("@Emp_DutyName", DBNull.Value); } else { idb.AddParameter("@Emp_DutyName", bse_Employee.Emp_DutyName); } } if(bse_Employee.Emp_Duty_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Duty)) { idb.AddParameter("@Emp_Duty", DBNull.Value); } else { idb.AddParameter("@Emp_Duty", bse_Employee.Emp_Duty); } } if(bse_Employee.Emp_Birth_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Birth)) { idb.AddParameter("@Emp_Birth", DBNull.Value); } else { idb.AddParameter("@Emp_Birth", bse_Employee.Emp_Birth); } } if(bse_Employee.Emp_StartDate_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_StartDate)) { idb.AddParameter("@Emp_StartDate", DBNull.Value); } else { idb.AddParameter("@Emp_StartDate", bse_Employee.Emp_StartDate); } } if(bse_Employee.Emp_Bak_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Bak)) { idb.AddParameter("@Emp_Bak", DBNull.Value); } else { idb.AddParameter("@Emp_Bak", bse_Employee.Emp_Bak); } } if(bse_Employee.Emp_CanLogin_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_CanLogin)) { idb.AddParameter("@Emp_CanLogin", DBNull.Value); } else { idb.AddParameter("@Emp_CanLogin", bse_Employee.Emp_CanLogin); } } if(bse_Employee.Emp_LoginID_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_LoginID)) { idb.AddParameter("@Emp_LoginID", DBNull.Value); } else { idb.AddParameter("@Emp_LoginID", bse_Employee.Emp_LoginID); } } if(bse_Employee.Emp_LoginPwd_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_LoginPwd)) { idb.AddParameter("@Emp_LoginPwd", DBNull.Value); } else { idb.AddParameter("@Emp_LoginPwd", bse_Employee.Emp_LoginPwd); } } if(bse_Employee.Emp_Mobile_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Mobile)) { idb.AddParameter("@Emp_Mobile", DBNull.Value); } else { idb.AddParameter("@Emp_Mobile", bse_Employee.Emp_Mobile); } } if(bse_Employee.Emp_HomeTel_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_HomeTel)) { idb.AddParameter("@Emp_HomeTel", DBNull.Value); } else { idb.AddParameter("@Emp_HomeTel", bse_Employee.Emp_HomeTel); } } if(bse_Employee.Emp_OffTel_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_OffTel)) { idb.AddParameter("@Emp_OffTel", DBNull.Value); } else { idb.AddParameter("@Emp_OffTel", bse_Employee.Emp_OffTel); } } if(bse_Employee.Stat_IsChanged) { if (bse_Employee.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", bse_Employee.Stat); } } if(bse_Employee.Emp_Stat_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Stat)) { idb.AddParameter("@Emp_Stat", DBNull.Value); } else { idb.AddParameter("@Emp_Stat", bse_Employee.Emp_Stat); } } if(bse_Employee.Emp_Date_IsChanged) { if (bse_Employee.Emp_Date == DateTime.MinValue) { idb.AddParameter("@Emp_Date", DBNull.Value); } else { idb.AddParameter("@Emp_Date", bse_Employee.Emp_Date); } } if(bse_Employee.Emp_Order_IsChanged) { if (bse_Employee.Emp_Order == 0) { idb.AddParameter("@Emp_Order", 0); } else { idb.AddParameter("@Emp_Order", bse_Employee.Emp_Order); } } idb.AddParameter("@Emp_ID", bse_Employee.Emp_ID); return idb.ExeCmd(sql);
private void Employee_Load(object sender, EventArgs e) { FormHelper gen = new FormHelper(); BindModelHelper helper = new BindModelHelper(); //表单生成 gen.GenerateForm("FEmp", this.groupBox1, new Point(6, 20)); gen.GenerateForm("FOEmp", this.panel2, new Point(6, 20)); gen.GenerateForm("FCEmp", this.panel1, new Point(6, 20)); switch (operationType) { case OperationTypeEnum.Look: this.btnSave.Enabled = false; break; } //编辑或添加判断 if (EmplyeeModel != null) { helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.groupBox1.Controls, ""); helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.panel1.Controls, ""); helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.panel2.Controls, ""); } else { EmplyeeModel = new Bse_Employee(); //EmplyeeModel.Emp_Code = EmployeeInstance.GenerateEmpCode(); helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.groupBox1.Controls, ""); helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.panel1.Controls, ""); helper.BindModelToControl<Bse_Employee>(EmplyeeModel, this.panel2.Controls, ""); } btnSave.Click += new EventHandler(btnSave_Click); //btnOk.Click += new EventHandler(btnOk_Click); //Emp_Dept_Code.Click += new EventHandler(Emp_Dept_Code_Click); //Emp_Dept_Name.Click += new EventHandler(Emp_Dept_Code_Click); btnCancle.Click += new EventHandler(btnCancle_Click); //LoadDict(); }
/// <summary> /// 更新Bse_Employee对象(即:一条记录 /// </summary> public int Update(Bse_Employee bse_Employee) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE Bse_Employee SET "); if(bse_Employee.Emp_Code_IsChanged){sbParameter.Append("Emp_Code=@Emp_Code, ");} if(bse_Employee.Emp_Name_IsChanged){sbParameter.Append("Emp_Name=@Emp_Name, ");} if(bse_Employee.Emp_Gendar_IsChanged){sbParameter.Append("Emp_Gendar=@Emp_Gendar, ");} if(bse_Employee.Emp_Dept_Code_IsChanged){sbParameter.Append("Emp_Dept_Code=@Emp_Dept_Code, ");} if(bse_Employee.Emp_Dept_Name_IsChanged){sbParameter.Append("Emp_Dept_Name=@Emp_Dept_Name, ");} if(bse_Employee.Emp_TitleName_IsChanged){sbParameter.Append("Emp_TitleName=@Emp_TitleName, ");} if(bse_Employee.Emp_Title_IsChanged){sbParameter.Append("Emp_Title=@Emp_Title, ");} if(bse_Employee.Emp_DutyName_IsChanged){sbParameter.Append("Emp_DutyName=@Emp_DutyName, ");} if(bse_Employee.Emp_Duty_IsChanged){sbParameter.Append("Emp_Duty=@Emp_Duty, ");} if(bse_Employee.Emp_Birth_IsChanged){sbParameter.Append("Emp_Birth=@Emp_Birth, ");} if(bse_Employee.Emp_StartDate_IsChanged){sbParameter.Append("Emp_StartDate=@Emp_StartDate, ");} if(bse_Employee.Emp_Bak_IsChanged){sbParameter.Append("Emp_Bak=@Emp_Bak, ");} if(bse_Employee.Emp_CanLogin_IsChanged){sbParameter.Append("Emp_CanLogin=@Emp_CanLogin, ");} if(bse_Employee.Emp_LoginID_IsChanged){sbParameter.Append("Emp_LoginID=@Emp_LoginID, ");} if(bse_Employee.Emp_LoginPwd_IsChanged){sbParameter.Append("Emp_LoginPwd=@Emp_LoginPwd, ");} if(bse_Employee.Emp_Mobile_IsChanged){sbParameter.Append("Emp_Mobile=@Emp_Mobile, ");} if(bse_Employee.Emp_HomeTel_IsChanged){sbParameter.Append("Emp_HomeTel=@Emp_HomeTel, ");} if(bse_Employee.Emp_OffTel_IsChanged){sbParameter.Append("Emp_OffTel=@Emp_OffTel, ");} if(bse_Employee.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(bse_Employee.Emp_Stat_IsChanged){sbParameter.Append("Emp_Stat=@Emp_Stat, ");} if(bse_Employee.Emp_Date_IsChanged){sbParameter.Append("Emp_Date=@Emp_Date, ");} if(bse_Employee.Emp_Order_IsChanged){sbParameter.Append("Emp_Order=@Emp_Order ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Emp_ID=@Emp_ID; " ); string sql=sb.ToString(); if(bse_Employee.Emp_Code_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Code)) { idb.AddParameter("@Emp_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Code", bse_Employee.Emp_Code); } } if(bse_Employee.Emp_Name_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Name)) { idb.AddParameter("@Emp_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Name", bse_Employee.Emp_Name); } } if(bse_Employee.Emp_Gendar_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Gendar)) { idb.AddParameter("@Emp_Gendar", DBNull.Value); } else { idb.AddParameter("@Emp_Gendar", bse_Employee.Emp_Gendar); } } if(bse_Employee.Emp_Dept_Code_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Code)) { idb.AddParameter("@Emp_Dept_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Code", bse_Employee.Emp_Dept_Code); } } if(bse_Employee.Emp_Dept_Name_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Name)) { idb.AddParameter("@Emp_Dept_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Name", bse_Employee.Emp_Dept_Name); } } if(bse_Employee.Emp_TitleName_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_TitleName)) { idb.AddParameter("@Emp_TitleName", DBNull.Value); } else { idb.AddParameter("@Emp_TitleName", bse_Employee.Emp_TitleName); } } if(bse_Employee.Emp_Title_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Title)) { idb.AddParameter("@Emp_Title", DBNull.Value); } else { idb.AddParameter("@Emp_Title", bse_Employee.Emp_Title); } } if(bse_Employee.Emp_DutyName_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_DutyName)) { idb.AddParameter("@Emp_DutyName", DBNull.Value); } else { idb.AddParameter("@Emp_DutyName", bse_Employee.Emp_DutyName); } } if(bse_Employee.Emp_Duty_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Duty)) { idb.AddParameter("@Emp_Duty", DBNull.Value); } else { idb.AddParameter("@Emp_Duty", bse_Employee.Emp_Duty); } } if(bse_Employee.Emp_Birth_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Birth)) { idb.AddParameter("@Emp_Birth", DBNull.Value); } else { idb.AddParameter("@Emp_Birth", bse_Employee.Emp_Birth); } } if(bse_Employee.Emp_StartDate_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_StartDate)) { idb.AddParameter("@Emp_StartDate", DBNull.Value); } else { idb.AddParameter("@Emp_StartDate", bse_Employee.Emp_StartDate); } } if(bse_Employee.Emp_Bak_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Bak)) { idb.AddParameter("@Emp_Bak", DBNull.Value); } else { idb.AddParameter("@Emp_Bak", bse_Employee.Emp_Bak); } } if(bse_Employee.Emp_CanLogin_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_CanLogin)) { idb.AddParameter("@Emp_CanLogin", DBNull.Value); } else { idb.AddParameter("@Emp_CanLogin", bse_Employee.Emp_CanLogin); } } if(bse_Employee.Emp_LoginID_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_LoginID)) { idb.AddParameter("@Emp_LoginID", DBNull.Value); } else { idb.AddParameter("@Emp_LoginID", bse_Employee.Emp_LoginID); } } if(bse_Employee.Emp_LoginPwd_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_LoginPwd)) { idb.AddParameter("@Emp_LoginPwd", DBNull.Value); } else { idb.AddParameter("@Emp_LoginPwd", bse_Employee.Emp_LoginPwd); } } if(bse_Employee.Emp_Mobile_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Mobile)) { idb.AddParameter("@Emp_Mobile", DBNull.Value); } else { idb.AddParameter("@Emp_Mobile", bse_Employee.Emp_Mobile); } } if(bse_Employee.Emp_HomeTel_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_HomeTel)) { idb.AddParameter("@Emp_HomeTel", DBNull.Value); } else { idb.AddParameter("@Emp_HomeTel", bse_Employee.Emp_HomeTel); } } if(bse_Employee.Emp_OffTel_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_OffTel)) { idb.AddParameter("@Emp_OffTel", DBNull.Value); } else { idb.AddParameter("@Emp_OffTel", bse_Employee.Emp_OffTel); } } if(bse_Employee.Stat_IsChanged) { if (bse_Employee.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", bse_Employee.Stat); } } if(bse_Employee.Emp_Stat_IsChanged) { if (string.IsNullOrEmpty(bse_Employee.Emp_Stat)) { idb.AddParameter("@Emp_Stat", DBNull.Value); } else { idb.AddParameter("@Emp_Stat", bse_Employee.Emp_Stat); } } if(bse_Employee.Emp_Date_IsChanged) { if (bse_Employee.Emp_Date == DateTime.MinValue) { idb.AddParameter("@Emp_Date", DBNull.Value); } else { idb.AddParameter("@Emp_Date", bse_Employee.Emp_Date); } } if(bse_Employee.Emp_Order_IsChanged) { if (bse_Employee.Emp_Order == 0) { idb.AddParameter("@Emp_Order", 0); } else { idb.AddParameter("@Emp_Order", bse_Employee.Emp_Order); } } idb.AddParameter("@Emp_ID", bse_Employee.Emp_ID); int Re = 0; //SQL日志记录 var RunMethod = System.Reflection.MethodBase.GetCurrentMethod(); System.Collections.Hashtable param = new System.Collections.Hashtable(); string Ex = string.Empty; foreach (System.Collections.DictionaryEntry item in idb.GetParameters()) { param.Add(item.Key, item.Value); } try { Re = idb.ExeCmd(sql); Ex = Re.ToString(); } catch (Exception ex) { Ex = ex.Message; } finally { SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex); } return Re;
/// <summary> /// 添加员工 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool InsertEmployee(Bse_Employee model) { //model.Emp_Code = GenerateEmpCode(); bool result = false; int _result = instance.Add(model); if (_result > 0) { result = true; } return result; }
public bool SaveData() { bool result = false; Bse_Employee model = new Bse_Employee(); BindModelHelper helper = new BindModelHelper(); //helper.BindControlToModel<Bse_Employee>(model, this.Controls); //var mobileEditor = helper.FindCtl<UltraTextEditor>(this.panel1.Controls, "Emp_Mobile"); helper.BindControlToModel<Bse_Employee>(model, this.groupBox1.Controls, ""); helper.BindControlToModel<Bse_Employee>(model, this.panel1.Controls, ""); helper.BindControlToModel<Bse_Employee>(model, this.panel2.Controls, ""); //if (string.IsNullOrEmpty(mobileEditor.Text)) //{ // model.Emp_Mobile = ""; //} //model.Emp_TitleName = Emp_Title.Text; //model.Emp_DutyName = Emp_Duty.Text; if (model != null) { switch (operationType) { case OperationTypeEnum.Look: break; case OperationTypeEnum.Edit: if (model.Emp_Code != EmplyeeModel.Emp_Code) { if (!CheckEmployeeIsExist(model.Emp_Code)) { result = EmployeeInstance.UpdateEmployee(model); } else { return false; } } else { result = EmployeeInstance.UpdateEmployee(model); } break; case OperationTypeEnum.Add: if (!CheckEmployeeIsExist(model.Emp_Code)) { //var order = Common.C_Class.Utils.TypeConverter.StrToInt(model.Emp_Code); //model.Emp_Order = order; //result = EmployeeInstance.InsertEmployee(model); } else { return false; } break; default: break; } } if (result) { Alert.Show("数据更新成功!"); if (DataChange != null) { DataChange(model, EventArgs.Empty); } } else { Alert.Show("数据更新失败!"); } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(Bse_Employee model, bool IsValid) { var e = new ModelExceptions(); bool result = false; if (e.IsValid && IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(Bse_Employee model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 添加Bse_Employee对象(即:一条记录) /// </summary> public int Add(Bse_Employee bse_Employee) { string sql = "INSERT INTO Bse_Employee (Emp_Code,Emp_Name,Emp_Gendar,Emp_Dept_Code,Emp_Dept_Name,Emp_TitleName,Emp_Title,Emp_DutyName,Emp_Duty,Emp_Birth,Emp_StartDate,Emp_Bak,Emp_CanLogin,Emp_LoginID,Emp_LoginPwd,Emp_Mobile,Emp_HomeTel,Emp_OffTel,Stat,Emp_Stat,Emp_Date,Emp_Order) VALUES (@Emp_Code,@Emp_Name,@Emp_Gendar,@Emp_Dept_Code,@Emp_Dept_Name,@Emp_TitleName,@Emp_Title,@Emp_DutyName,@Emp_Duty,@Emp_Birth,@Emp_StartDate,@Emp_Bak,@Emp_CanLogin,@Emp_LoginID,@Emp_LoginPwd,@Emp_Mobile,@Emp_HomeTel,@Emp_OffTel,@Stat,@Emp_Stat,@Emp_Date,@Emp_Order)"; if (string.IsNullOrEmpty(bse_Employee.Emp_Code)) { idb.AddParameter("@Emp_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Code", bse_Employee.Emp_Code); } if (string.IsNullOrEmpty(bse_Employee.Emp_Name)) { idb.AddParameter("@Emp_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Name", bse_Employee.Emp_Name); } if (string.IsNullOrEmpty(bse_Employee.Emp_Gendar)) { idb.AddParameter("@Emp_Gendar", DBNull.Value); } else { idb.AddParameter("@Emp_Gendar", bse_Employee.Emp_Gendar); } if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Code)) { idb.AddParameter("@Emp_Dept_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Code", bse_Employee.Emp_Dept_Code); } if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Name)) { idb.AddParameter("@Emp_Dept_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Name", bse_Employee.Emp_Dept_Name); } if (string.IsNullOrEmpty(bse_Employee.Emp_TitleName)) { idb.AddParameter("@Emp_TitleName", DBNull.Value); } else { idb.AddParameter("@Emp_TitleName", bse_Employee.Emp_TitleName); } if (string.IsNullOrEmpty(bse_Employee.Emp_Title)) { idb.AddParameter("@Emp_Title", DBNull.Value); } else { idb.AddParameter("@Emp_Title", bse_Employee.Emp_Title); } if (string.IsNullOrEmpty(bse_Employee.Emp_DutyName)) { idb.AddParameter("@Emp_DutyName", DBNull.Value); } else { idb.AddParameter("@Emp_DutyName", bse_Employee.Emp_DutyName); } if (string.IsNullOrEmpty(bse_Employee.Emp_Duty)) { idb.AddParameter("@Emp_Duty", DBNull.Value); } else { idb.AddParameter("@Emp_Duty", bse_Employee.Emp_Duty); } if (string.IsNullOrEmpty(bse_Employee.Emp_Birth)) { idb.AddParameter("@Emp_Birth", DBNull.Value); } else { idb.AddParameter("@Emp_Birth", bse_Employee.Emp_Birth); } if (string.IsNullOrEmpty(bse_Employee.Emp_StartDate)) { idb.AddParameter("@Emp_StartDate", DBNull.Value); } else { idb.AddParameter("@Emp_StartDate", bse_Employee.Emp_StartDate); } if (string.IsNullOrEmpty(bse_Employee.Emp_Bak)) { idb.AddParameter("@Emp_Bak", DBNull.Value); } else { idb.AddParameter("@Emp_Bak", bse_Employee.Emp_Bak); } if (string.IsNullOrEmpty(bse_Employee.Emp_CanLogin)) { idb.AddParameter("@Emp_CanLogin", DBNull.Value); } else { idb.AddParameter("@Emp_CanLogin", bse_Employee.Emp_CanLogin); } if (string.IsNullOrEmpty(bse_Employee.Emp_LoginID)) { idb.AddParameter("@Emp_LoginID", DBNull.Value); } else { idb.AddParameter("@Emp_LoginID", bse_Employee.Emp_LoginID); } if (string.IsNullOrEmpty(bse_Employee.Emp_LoginPwd)) { idb.AddParameter("@Emp_LoginPwd", DBNull.Value); } else { idb.AddParameter("@Emp_LoginPwd", bse_Employee.Emp_LoginPwd); } if (string.IsNullOrEmpty(bse_Employee.Emp_Mobile)) { idb.AddParameter("@Emp_Mobile", DBNull.Value); } else { idb.AddParameter("@Emp_Mobile", bse_Employee.Emp_Mobile); } if (string.IsNullOrEmpty(bse_Employee.Emp_HomeTel)) { idb.AddParameter("@Emp_HomeTel", DBNull.Value); } else { idb.AddParameter("@Emp_HomeTel", bse_Employee.Emp_HomeTel); } if (string.IsNullOrEmpty(bse_Employee.Emp_OffTel)) { idb.AddParameter("@Emp_OffTel", DBNull.Value); } else { idb.AddParameter("@Emp_OffTel", bse_Employee.Emp_OffTel); } if (bse_Employee.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", bse_Employee.Stat); } if (string.IsNullOrEmpty(bse_Employee.Emp_Stat)) { idb.AddParameter("@Emp_Stat", DBNull.Value); } else { idb.AddParameter("@Emp_Stat", bse_Employee.Emp_Stat); } if (bse_Employee.Emp_Date == DateTime.MinValue) { idb.AddParameter("@Emp_Date", DBNull.Value); } else { idb.AddParameter("@Emp_Date", bse_Employee.Emp_Date); } if (bse_Employee.Emp_Order == 0) { idb.AddParameter("@Emp_Order", 0); } else { idb.AddParameter("@Emp_Order", bse_Employee.Emp_Order); } int Re = 0; //SQL日志记录 var RunMethod = System.Reflection.MethodBase.GetCurrentMethod(); System.Collections.Hashtable param = new System.Collections.Hashtable(); string Ex = string.Empty; foreach (System.Collections.DictionaryEntry item in idb.GetParameters()) { param.Add(item.Key, item.Value); } try { Re = idb.ExeCmd(sql); Ex = Re.ToString(); } catch (Exception ex) { Ex = ex.Message; } finally { SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex); } return Re; }
/// <summary> /// 获取指定的Bse_Employee对象集合 /// </summary> public List<Bse_Employee> GetListByWhere(string strCondition) { List<Bse_Employee> ret = new List<Bse_Employee>(); string sql = "SELECT Emp_ID,Emp_Code,Emp_Name,Emp_Gendar,Emp_Dept_Code,Emp_Dept_Name,Emp_TitleName,Emp_Title,Emp_DutyName,Emp_Duty,Emp_Birth,Emp_StartDate,Emp_Bak,Emp_CanLogin,Emp_LoginID,Emp_LoginPwd,Emp_Mobile,Emp_HomeTel,Emp_OffTel,Stat,Emp_Stat,Emp_Date,Emp_Order FROM Bse_Employee WHERE 1=1 AND ((Stat is null) or (Stat=0) ) "; if(!string.IsNullOrEmpty(strCondition)) { strCondition.Replace('\'','"'); //防sql注入 sql += strCondition ; } sql += " ORDER BY Emp_ID DESC "; SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { Bse_Employee bse_Employee = new Bse_Employee(); if (dr["Emp_ID"] != DBNull.Value) bse_Employee.Emp_ID = Convert.ToInt64(dr["Emp_ID"]); if (dr["Emp_Code"] != DBNull.Value) bse_Employee.Emp_Code = Convert.ToString(dr["Emp_Code"]); if (dr["Emp_Name"] != DBNull.Value) bse_Employee.Emp_Name = Convert.ToString(dr["Emp_Name"]); if (dr["Emp_Gendar"] != DBNull.Value) bse_Employee.Emp_Gendar = Convert.ToString(dr["Emp_Gendar"]); if (dr["Emp_Dept_Code"] != DBNull.Value) bse_Employee.Emp_Dept_Code = Convert.ToString(dr["Emp_Dept_Code"]); if (dr["Emp_Dept_Name"] != DBNull.Value) bse_Employee.Emp_Dept_Name = Convert.ToString(dr["Emp_Dept_Name"]); if (dr["Emp_TitleName"] != DBNull.Value) bse_Employee.Emp_TitleName = Convert.ToString(dr["Emp_TitleName"]); if (dr["Emp_Title"] != DBNull.Value) bse_Employee.Emp_Title = Convert.ToString(dr["Emp_Title"]); if (dr["Emp_DutyName"] != DBNull.Value) bse_Employee.Emp_DutyName = Convert.ToString(dr["Emp_DutyName"]); if (dr["Emp_Duty"] != DBNull.Value) bse_Employee.Emp_Duty = Convert.ToString(dr["Emp_Duty"]); if (dr["Emp_Birth"] != DBNull.Value) bse_Employee.Emp_Birth = Convert.ToString(dr["Emp_Birth"]); if (dr["Emp_StartDate"] != DBNull.Value) bse_Employee.Emp_StartDate = Convert.ToString(dr["Emp_StartDate"]); if (dr["Emp_Bak"] != DBNull.Value) bse_Employee.Emp_Bak = Convert.ToString(dr["Emp_Bak"]); if (dr["Emp_CanLogin"] != DBNull.Value) bse_Employee.Emp_CanLogin = Convert.ToString(dr["Emp_CanLogin"]); if (dr["Emp_LoginID"] != DBNull.Value) bse_Employee.Emp_LoginID = Convert.ToString(dr["Emp_LoginID"]); if (dr["Emp_LoginPwd"] != DBNull.Value) bse_Employee.Emp_LoginPwd = Convert.ToString(dr["Emp_LoginPwd"]); if (dr["Emp_Mobile"] != DBNull.Value) bse_Employee.Emp_Mobile = Convert.ToString(dr["Emp_Mobile"]); if (dr["Emp_HomeTel"] != DBNull.Value) bse_Employee.Emp_HomeTel = Convert.ToString(dr["Emp_HomeTel"]); if (dr["Emp_OffTel"] != DBNull.Value) bse_Employee.Emp_OffTel = Convert.ToString(dr["Emp_OffTel"]); if (dr["Stat"] != DBNull.Value) bse_Employee.Stat = Convert.ToInt32(dr["Stat"]); if (dr["Emp_Stat"] != DBNull.Value) bse_Employee.Emp_Stat = Convert.ToString(dr["Emp_Stat"]); if (dr["Emp_Date"] != DBNull.Value) bse_Employee.Emp_Date = Convert.ToDateTime(dr["Emp_Date"]); if (dr["Emp_Order"] != DBNull.Value) bse_Employee.Emp_Order = Convert.ToInt32(dr["Emp_Order"]); ret.Add(bse_Employee); } }catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return ret; }
/// <summary> /// 获取指定的Bse_Employee对象(即:一条记录 /// </summary> public Bse_Employee GetByKey(Int64 emp_ID) { Bse_Employee bse_Employee = new Bse_Employee(); string sql = "SELECT Emp_ID,Emp_Code,Emp_Name,Emp_Gendar,Emp_Dept_Code,Emp_Dept_Name,Emp_TitleName,Emp_Title,Emp_DutyName,Emp_Duty,Emp_Birth,Emp_StartDate,Emp_Bak,Emp_CanLogin,Emp_LoginID,Emp_LoginPwd,Emp_Mobile,Emp_HomeTel,Emp_OffTel,Stat,Emp_Stat,Emp_Date,Emp_Order FROM Bse_Employee WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Emp_ID=@Emp_ID "; idb.AddParameter("@Emp_ID", emp_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["Emp_ID"] != DBNull.Value) bse_Employee.Emp_ID = Convert.ToInt64(dr["Emp_ID"]); if (dr["Emp_Code"] != DBNull.Value) bse_Employee.Emp_Code = Convert.ToString(dr["Emp_Code"]); if (dr["Emp_Name"] != DBNull.Value) bse_Employee.Emp_Name = Convert.ToString(dr["Emp_Name"]); if (dr["Emp_Gendar"] != DBNull.Value) bse_Employee.Emp_Gendar = Convert.ToString(dr["Emp_Gendar"]); if (dr["Emp_Dept_Code"] != DBNull.Value) bse_Employee.Emp_Dept_Code = Convert.ToString(dr["Emp_Dept_Code"]); if (dr["Emp_Dept_Name"] != DBNull.Value) bse_Employee.Emp_Dept_Name = Convert.ToString(dr["Emp_Dept_Name"]); if (dr["Emp_TitleName"] != DBNull.Value) bse_Employee.Emp_TitleName = Convert.ToString(dr["Emp_TitleName"]); if (dr["Emp_Title"] != DBNull.Value) bse_Employee.Emp_Title = Convert.ToString(dr["Emp_Title"]); if (dr["Emp_DutyName"] != DBNull.Value) bse_Employee.Emp_DutyName = Convert.ToString(dr["Emp_DutyName"]); if (dr["Emp_Duty"] != DBNull.Value) bse_Employee.Emp_Duty = Convert.ToString(dr["Emp_Duty"]); if (dr["Emp_Birth"] != DBNull.Value) bse_Employee.Emp_Birth = Convert.ToString(dr["Emp_Birth"]); if (dr["Emp_StartDate"] != DBNull.Value) bse_Employee.Emp_StartDate = Convert.ToString(dr["Emp_StartDate"]); if (dr["Emp_Bak"] != DBNull.Value) bse_Employee.Emp_Bak = Convert.ToString(dr["Emp_Bak"]); if (dr["Emp_CanLogin"] != DBNull.Value) bse_Employee.Emp_CanLogin = Convert.ToString(dr["Emp_CanLogin"]); if (dr["Emp_LoginID"] != DBNull.Value) bse_Employee.Emp_LoginID = Convert.ToString(dr["Emp_LoginID"]); if (dr["Emp_LoginPwd"] != DBNull.Value) bse_Employee.Emp_LoginPwd = Convert.ToString(dr["Emp_LoginPwd"]); if (dr["Emp_Mobile"] != DBNull.Value) bse_Employee.Emp_Mobile = Convert.ToString(dr["Emp_Mobile"]); if (dr["Emp_HomeTel"] != DBNull.Value) bse_Employee.Emp_HomeTel = Convert.ToString(dr["Emp_HomeTel"]); if (dr["Emp_OffTel"] != DBNull.Value) bse_Employee.Emp_OffTel = Convert.ToString(dr["Emp_OffTel"]); if (dr["Stat"] != DBNull.Value) bse_Employee.Stat = Convert.ToInt32(dr["Stat"]); if (dr["Emp_Stat"] != DBNull.Value) bse_Employee.Emp_Stat = Convert.ToString(dr["Emp_Stat"]); if (dr["Emp_Date"] != DBNull.Value) bse_Employee.Emp_Date = Convert.ToDateTime(dr["Emp_Date"]); if (dr["Emp_Order"] != DBNull.Value) bse_Employee.Emp_Order = Convert.ToInt32(dr["Emp_Order"]); } }catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return bse_Employee; }
/// <summary> /// 添加Bse_Employee对象(即:一条记录) /// </summary> public int Add(Bse_Employee bse_Employee) { string sql = "INSERT INTO Bse_Employee (Emp_Code,Emp_Name,Emp_Gendar,Emp_Dept_Code,Emp_Dept_Name,Emp_TitleName,Emp_Title,Emp_DutyName,Emp_Duty,Emp_Birth,Emp_StartDate,Emp_Bak,Emp_CanLogin,Emp_LoginID,Emp_LoginPwd,Emp_Mobile,Emp_HomeTel,Emp_OffTel,Stat,Emp_Stat,Emp_Date,Emp_Order) VALUES (@Emp_Code,@Emp_Name,@Emp_Gendar,@Emp_Dept_Code,@Emp_Dept_Name,@Emp_TitleName,@Emp_Title,@Emp_DutyName,@Emp_Duty,@Emp_Birth,@Emp_StartDate,@Emp_Bak,@Emp_CanLogin,@Emp_LoginID,@Emp_LoginPwd,@Emp_Mobile,@Emp_HomeTel,@Emp_OffTel,@Stat,@Emp_Stat,@Emp_Date,@Emp_Order)"; if (string.IsNullOrEmpty(bse_Employee.Emp_Code)) { idb.AddParameter("@Emp_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Code", bse_Employee.Emp_Code); } if (string.IsNullOrEmpty(bse_Employee.Emp_Name)) { idb.AddParameter("@Emp_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Name", bse_Employee.Emp_Name); } if (string.IsNullOrEmpty(bse_Employee.Emp_Gendar)) { idb.AddParameter("@Emp_Gendar", DBNull.Value); } else { idb.AddParameter("@Emp_Gendar", bse_Employee.Emp_Gendar); } if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Code)) { idb.AddParameter("@Emp_Dept_Code", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Code", bse_Employee.Emp_Dept_Code); } if (string.IsNullOrEmpty(bse_Employee.Emp_Dept_Name)) { idb.AddParameter("@Emp_Dept_Name", DBNull.Value); } else { idb.AddParameter("@Emp_Dept_Name", bse_Employee.Emp_Dept_Name); } if (string.IsNullOrEmpty(bse_Employee.Emp_TitleName)) { idb.AddParameter("@Emp_TitleName", DBNull.Value); } else { idb.AddParameter("@Emp_TitleName", bse_Employee.Emp_TitleName); } if (string.IsNullOrEmpty(bse_Employee.Emp_Title)) { idb.AddParameter("@Emp_Title", DBNull.Value); } else { idb.AddParameter("@Emp_Title", bse_Employee.Emp_Title); } if (string.IsNullOrEmpty(bse_Employee.Emp_DutyName)) { idb.AddParameter("@Emp_DutyName", DBNull.Value); } else { idb.AddParameter("@Emp_DutyName", bse_Employee.Emp_DutyName); } if (string.IsNullOrEmpty(bse_Employee.Emp_Duty)) { idb.AddParameter("@Emp_Duty", DBNull.Value); } else { idb.AddParameter("@Emp_Duty", bse_Employee.Emp_Duty); } if (string.IsNullOrEmpty(bse_Employee.Emp_Birth)) { idb.AddParameter("@Emp_Birth", DBNull.Value); } else { idb.AddParameter("@Emp_Birth", bse_Employee.Emp_Birth); } if (string.IsNullOrEmpty(bse_Employee.Emp_StartDate)) { idb.AddParameter("@Emp_StartDate", DBNull.Value); } else { idb.AddParameter("@Emp_StartDate", bse_Employee.Emp_StartDate); } if (string.IsNullOrEmpty(bse_Employee.Emp_Bak)) { idb.AddParameter("@Emp_Bak", DBNull.Value); } else { idb.AddParameter("@Emp_Bak", bse_Employee.Emp_Bak); } if (string.IsNullOrEmpty(bse_Employee.Emp_CanLogin)) { idb.AddParameter("@Emp_CanLogin", DBNull.Value); } else { idb.AddParameter("@Emp_CanLogin", bse_Employee.Emp_CanLogin); } if (string.IsNullOrEmpty(bse_Employee.Emp_LoginID)) { idb.AddParameter("@Emp_LoginID", DBNull.Value); } else { idb.AddParameter("@Emp_LoginID", bse_Employee.Emp_LoginID); } if (string.IsNullOrEmpty(bse_Employee.Emp_LoginPwd)) { idb.AddParameter("@Emp_LoginPwd", DBNull.Value); } else { idb.AddParameter("@Emp_LoginPwd", bse_Employee.Emp_LoginPwd); } if (string.IsNullOrEmpty(bse_Employee.Emp_Mobile)) { idb.AddParameter("@Emp_Mobile", DBNull.Value); } else { idb.AddParameter("@Emp_Mobile", bse_Employee.Emp_Mobile); } if (string.IsNullOrEmpty(bse_Employee.Emp_HomeTel)) { idb.AddParameter("@Emp_HomeTel", DBNull.Value); } else { idb.AddParameter("@Emp_HomeTel", bse_Employee.Emp_HomeTel); } if (string.IsNullOrEmpty(bse_Employee.Emp_OffTel)) { idb.AddParameter("@Emp_OffTel", DBNull.Value); } else { idb.AddParameter("@Emp_OffTel", bse_Employee.Emp_OffTel); } if (bse_Employee.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", bse_Employee.Stat); } if (string.IsNullOrEmpty(bse_Employee.Emp_Stat)) { idb.AddParameter("@Emp_Stat", DBNull.Value); } else { idb.AddParameter("@Emp_Stat", bse_Employee.Emp_Stat); } if (bse_Employee.Emp_Date == DateTime.MinValue) { idb.AddParameter("@Emp_Date", DBNull.Value); } else { idb.AddParameter("@Emp_Date", bse_Employee.Emp_Date); } if (bse_Employee.Emp_Order == 0) { idb.AddParameter("@Emp_Order", 0); } else { idb.AddParameter("@Emp_Order", bse_Employee.Emp_Order); } return idb.ExeCmd(sql); }
/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(Bse_Employee model, bool IsValid) { bool result = false; var e = new ModelExceptions(); if (e.IsValid && IsValid) { int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return result; }