public ActionResult FlowConfig_FindByPage(Mes_Sys_FlowConfig obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesSysFlowConfigDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
/// <summary>
/// 保存记录
/// </summary>
/// <returns></returns>
public ActionResult FlowConfig_Save(Mes_Sys_FlowConfig obj)
{
//判断数据有效性
if (string.IsNullOrEmpty(obj.OptUserName))
{
return(Json(new { IsSuccess = false, Message = "操作人员不可为空" }, JsonRequestBehavior.AllowGet));
}
if (obj.ID <= 0)
{
obj.Creater = base.CurUser.UserId;
obj.CreatedTime = DateTime.Now;
}
int result = MesSysFlowConfigDao.Instance.Save(obj);
if (result <= 0)
{
return(Json(new { IsSuccess = false, Message = "保存失败" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, Message = "" }, JsonRequestBehavior.AllowGet));
}
public List <Mes_Sys_FlowConfig> FindByPage(Mes_Sys_FlowConfig obj, ref PagerBase pager)
{
string sql = @"SELECT T1.* FROM Mes_Sys_FlowConfig T1
WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.BusinessType))
{
sql += string.Format(" AND T1.BusinessType ='{0}'", obj.BusinessType);
}
if (!string.IsNullOrEmpty(obj.OptUserName))
{
sql += string.Format(" AND T1.OptUserName LIKE '%{0}%'", obj.OptUserName);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
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_FlowConfig>());
}
