public bool DeleteEmployee(Bse_Employee model)
{
bool result = false;
model.Stat = 1;
int _result = instance.Update(model);
if (_result > 0)
{
result = true;
}
return result;
}
/// <summary>
/// 角色分配
/// </summary>
/// <param name="UCode"></param>
/// <param name="role"></param>
/// <returns></returns>
public ActionResult AllotRole(string UCode, string role)
{
Bse_Employee stuff = hrInstance.GetModelByCode(UCode);
Sys_Role rl = rInstance.GetModel(string.Format("AND SRole_Code='{0}'", role));
//stuff. = rl.SRole_Code;
//stuff.Stuff_RoleName = rl.SRole_Name;
hrInstance.Update(stuff);
return(new JsonResult {
Data = new { result = "success", Msg = "数据更新成功！" }
});
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Bse_Employee model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Bse_Employee GetModel(string strCondition)
{
List <Bse_Employee> list = instance.GetListByWhere(strCondition);
Bse_Employee model = new Bse_Employee();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <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'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <Bse_Employee> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Bse_Employee model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 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);
}
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;
}
//密码有效性验证
else if (model.Emp_LoginPwd.Equals(password))
{
re = LoginResultEnum.Success;
}
else
{
re = LoginResultEnum.InValidPwd;
}
}
else
{
re = LoginResultEnum.NoExsist;
}
}
catch (Exception e)
{
//Alert.Show(e.Message);
re = LoginResultEnum.Fail;
}
//权限
return re;
}
/// <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 void UpdateEmployeeExtList(Bse_Employee model, List<Bse_EmployeeExt> list)
{
var oldlist = GetEmployeeExtend(model.Emp_Code);
oldlist.RemoveAll(o => o.EmpE_Module == "bse");
foreach (Bse_EmployeeExt r in oldlist)
{
var temp = list.FirstOrDefault(o => o.EmpE_ID == r.EmpE_ID);
//如果存在则更新
if (temp != null)
{
//temp.CreateDate = DateTime.Now;
temp.EmpE_ID = r.EmpE_ID;
eInstance.Update(temp);
list.Remove(temp);
}//不存在则删除
else
{
r.Stat = 1;
eInstance.Update(r);
}
}
foreach (Bse_EmployeeExt detail in list)
{
//如果有编码生成，则在此处完成
eInstance.Add(detail);
}
}
/// <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 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>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Bse_Employee GetModel(int id)
{
Bse_Employee model = instance.GetByKey(id);
return(model);
}
/// <summary>
/// 获取所有的Bse_Employee对象(即:一条记录
/// </summary>
public List <Bse_Employee> GetAll()
{
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) ) 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 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));
}
/// <summary>
/// 添加Bse_Employee对象(即:一条记录)
/// </summary>
public object AddWithReturn(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);SELECT @@IDENTITY AS ReturnID;";
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.ReturnValue(sql));
}
