/// <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="userName">用户名</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序号</param> /// <returns>流程草稿列表</returns> public static IList <dynamic> GetDataOfDraft(string userName, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); //var dao = new FLOWDAO(); var sql = string.Format("SELECT * FROM V_BIZ_FINO_BWA_DRAFT WHERE FLOWSTARTER='{0}'", userName); return(QueryService.GetData(sql, 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> /// 从CCFlow获取节点分页数据 /// </summary> /// <param name="page">页</param> /// <param name="rows">行</param> /// <param name="filterStr">过滤条件</param> /// <param name="orders">排序</param> /// <returns>节点分页记录集</returns> public static object GetPagedFromCCFlow(int page, int rows, string filterStr = "[]", string orders = "") { var filter = QueryService.DeserializeFilter(filterStr); //var dao = new NODEDAO(); var sql = "SELECT NODEID AS ID,NAME,STEP,FK_FLOW AS Definition_id FROM WF_NODE"; //var result = QueryService.CreatePagedSQLQuery(DataContextNH., sql, page, rows, filter, orders); var result = DataContextNH.GetBySQL <dynamic, dynamic>(sql); return(result); }