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