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