public List <Mes_Sys_Employee> FindByPage(Mes_Sys_Employee obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.OrgName FROM Mes_Sys_Employee T1 WITH(NOLOCK)
LEFT JOIN dbo.Mes_Sys_Organization T2 WITH(NOLOCK) ON T1.OrgID = T2.ID
WHERE T1.RecordStatus=1";
if (!string.IsNullOrEmpty(obj.EmpNo))
{
sql = sql + string.Format(" AND T1.EmpNo='{0}'", obj.EmpNo);
}
if (!string.IsNullOrEmpty(obj.EmpName))
{
sql = sql + string.Format(" AND T1.EmpName LIKE '%{0}%'", obj.EmpName);
}
if (obj.OrgID > 0)
{
sql = sql + string.Format(" AND T1.OrgID = {0}", obj.OrgID);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Sys_Employee>());
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="obj"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult EmployeeMgt_FindByPage(Mes_Sys_Employee obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesSysEmployeeDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取单个用户实体
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Mes_Sys_Employee GetUser(Mes_Sys_Employee obj)
{
string sql = "SELECT TOP 1 T1.* FROM Mes_Sys_Employee T1 WITH (NOLOCK) WHERE T1.RecordStatus=1";
if (!string.IsNullOrEmpty(obj.EmpNo))
{
sql = sql + string.Format(" AND T1.EmpNo='{0}'", obj.EmpNo);
}
if (!string.IsNullOrEmpty(obj.EmpName))
{
sql = sql + string.Format(" AND T1.EmpName LIKE '%{0}%'", obj.EmpName);
}
return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Sys_Employee>());
}
public ActionResult EmployeeMgt_Delete(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Sys_Employee obj = MesSysEmployeeDao.Instance.Find <Mes_Sys_Employee, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "员工信息有误！" }));
}
MesSysEmployeeDao.Instance.Delete <Mes_Sys_Employee>(obj);
return(Json(new { IsSuccess = true, Message = "" }));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult EmployeeMgt_Save(Mes_Sys_Employee obj)
{
if (string.IsNullOrEmpty(obj.EmpNo))
{
return(Json(new { IsSuccess = false, Message = "工号不能为空！" }));
}
if (string.IsNullOrEmpty(obj.EmpName))
{
return(Json(new { IsSuccess = false, Message = "用户名不能为空！" }));
}
if (obj.ID <= 0)
{
obj.RecordStatus = YesNoType.Yes;
obj.Creater = base.CurUser.UserId;
obj.CreatedTime = DateTime.Now;
}
MesSysEmployeeDao.Instance.Save(obj);
return(Json(new { IsSuccess = true, Message = "操作成功！" }));
}
