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;
}
