/// <summary> /// 获取岗位待办 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="userName">用户名</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>岗位待办分页列表</returns> public static PaginationInfo GetMyPagedOfStation(int page, int rows, string userName, string filterStr = "[]", string orders = "") { //var dao = new BWADAO(); var filter = QueryService.DeserializeFilter(filterStr); var sql = string.Format("SELECT * FROM V_BIZ_INFO_BWA_GWDB WHERE FK_Emp='{0}' OR AUTHOR='{0}' ORDER BY RDT DESC", userName); return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }
/// <summary> /// 获取退件列表 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="userName">用户名</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>退件分页结果集</returns> public static PaginationInfo GetPagedOfReturn(int page, int rows, string userName, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); var sql = string.Format("SELECT * FROM V_BIZ_FINO_BWA_ALL WHERE FID=0 AND WFSTATE=7 ORDER BY RDT DESC", userName); //var dao = new FLOWDAO(); return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }
/// <summary> /// 获取流程转发列表 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="userName">用户名</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>转发分页记录集</returns> public static PaginationInfo GetMyPageOfShift(int page, int rows, string userName, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); var sql = string.Format("SELECT * FROM V_BIZ_FINO_BWA_SHIFT WHERE FK_EMP='{0}' ORDER BY RDT DESC", userName); //var dao = new FLOWDAO(); return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }
/// <summary> /// 业务查询列表 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>业务查询分页列表</returns> public static PaginationInfo GetPagedOfYWCX(int page, int rows, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); var sql = "SELECT * FROM V_BIZ_INFO_BWA_YWCX ORDER BY TO_NUMBER(ID) DESC,ISPASS DESC,CDT ASC"; //var dao = new BWADAO(); return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }
/// <summary> /// 获取用户草稿分页信息 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="userName">用户名</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>草稿分页列表</returns> public static PaginationInfo GetMyPagedOfDraft(int page, int rows, string userName, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); //var dao = new BWADAO(); var sql = string.Format("SELECT * FROM V_BIZ_FINO_BWA_DRAFT WHERE FLOWSTARTER='{0}'", userName); return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }
/// <summary> /// 获取分页数据RoleAuthorization /// </summary> /// <returns></returns> public ActionResult GetTreePaged_RoleAuthorization(string id, string RoleID, int page, int rows, List <MyFilter> filters, string orders = "") { filters = filters == null ? new List <MyFilter>() : filters; var sql = string.Format("SELECT T.* FROM V_Auth_Rlt_RoleAuthorization T WHERE T.RoleID='{0}'", RoleID); if (!string.IsNullOrEmpty(id)) { sql = string.Format("{0} AND T.ParentID='{1}'", sql, id); var data = QueryService.GetData(sql); return(Json_Get(data)); } sql += " AND (T.ParentID IS NULL OR T.ParentID='')"; var result = QueryService.CreatePagedSQLQuery(sql, page, rows, filters, orders); return(Json_Get(new { total = result.total, rows = result.rows })); }
/// <summary> /// 已办业务查询 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>业务查询分页列表</returns> public static PaginationInfo GetPagedOfYWCX_YB(int page, int rows, List <Filter> filter, string orders = "") { var sql = "SELECT * FROM V_BIZ_INFO_BWA_YWCX_YB"; return(QueryService.CreatePagedSQLQuery(sql, page, rows, filter, orders, true)); }