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