public string JsonDataForEasyUIdataGrid(string tablename, int pageindex, int pagesize, string filterJson, string sort = "keyid", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage(tablename)
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = sortorder,
WhereString = FilterTranslator.ToSql(filterJson)
};
int recordCount;
DataTable dt = GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public IEnumerable <T> JsonDataForEasyUIdataGrid(ref int recordCount, string tablename, int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage(tablename)
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = sortorder,
WhereString = FilterTranslator.ToSql(filterJson)
};
//DataTable dt = GetPageWithSp(pcp, out recordCount);
IEnumerable <T> list = GetList <T>(GetPageWithSp(pcp, out recordCount));
return(list);
}
/// <summary>
/// 得到用户表单分页列表
/// </summary>
/// <param name="ctx"></param>
public void GetUserControlByPage(HttpContext ctx)
{
string where = "";
string filters = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("filter"));
if (filters != "")
{
where = FilterTranslator.ToSql(filters);
}
var pageParam = new PageParam(ctx);
int recordCount;
var dt = RDIFrameworkService.Instance.WorkFlowUserControlService.GetUserControlByPage(Utils.UserInfo, where, out recordCount, pageParam.PageIndex, pageParam.PageSize);
var json = JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt);
ctx.Response.Write(json);
}
public string JsonDataForEasyUIdataGrid(string tablename, int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage(tablename)
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = sortorder.Trim(),
SQL_WHERE_IN = FilterTranslator.ToSql(filterJson)
};
// LogHelper.WriteLog("where: "+pcp.SQL_WHERE_IN);
int recordCount;
//DataTable dt = GetPageWithSp(pcp, out recordCount);
IEnumerable <T> list = GetList <T>(GetPageWithSp(pcp, out recordCount));
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, list));
}
public string GetJsonData(int pageindex, int pagesize, string filterJson, string sort, string order)
{
var pcp = new ProcCustomPage("v_user")
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = (sort + " " + order).Trim(),
SQL_WHERE_IN = FilterTranslator.ToSql(filterJson)
};
//var users = UserDal.Instance.GetAll();
int recordCount;
if (pcp.SQL_WHERE_IN == "()")
{
pcp.SQL_WHERE_IN = "";
}
DataTable dt = UserDal.Instance.GetPageWithSp(pcp, out recordCount);
dt.Columns.Add(new DataColumn("depname"));
dt.Columns.Add(new DataColumn("Departments")); //可以访问的部门数据
//var departments = DepartmentDal.Instance.GetAll().ToList();
//foreach (DataRow row in dt.Rows)
//{
// var row1 = row;
// var dep = departments.Where(n => row1 != null && n.FID == PublicMethod.GetString(row1["departmentid"]));
// var enumerable = dep as Department[] ?? dep.ToArray();
// if (enumerable.Any())
// row["depname"] = enumerable.First().DepartmentName;
// else
// {
// row["depname"] = "";
// }
// var userList = users as IList<User> ?? users.ToList();
// row["Departments"] = userList.First(n => n.FID == PublicMethod.GetString(row["FID"])).Departments;
//}
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
/// <summary>
/// 得到我参与的任务列表
/// </summary>
/// <param name="ctx"></param>
private void GetWorkFlowAllTaskByPage(HttpContext ctx)
{
string where = "";
string filters = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("filter"));
if (filters != "")
{
where = FilterTranslator.ToSql(filters);
}
var pageParam = new PageParam(ctx);
if (SystemInfo.WorkFlowDbType == CurrentDbType.Oracle && !string.IsNullOrEmpty(where))
{
where = where.Replace("TASKSTARTTIME", "TO_CHAR(TASKSTARTTIME, 'yyyy-mm-dd')");
}
where = string.IsNullOrEmpty(where) ? "" : System.Web.HttpUtility.UrlDecode(where);
int recordCount;
var dtAllMyTask = RDIFrameworkService.Instance.WorkFlowInstanceService.WorkFlowAllTaskByPage(Utils.UserInfo, Utils.UserInfo.Id, out recordCount, pageParam.PageIndex, pageParam.PageSize, "All", where);
var json = JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dtAllMyTask);
ctx.Response.Write(json);
}
public string GetJsonData(int pageindex, int pagesize, string filterJson, string sort, string order)
{
var pcp = new ProcCustomPage("sys_Users")
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = sort + " " + order,
WhereString = FilterTranslator.ToSql(filterJson)
};
var users = UserDal.Instance.GetAll();
int recordCount;
DataTable dt = UserDal.Instance.GetPageWithSp(pcp, out recordCount);
dt.Columns.Add(new DataColumn("depname"));
dt.Columns.Add(new DataColumn("Departments")); //可以访问的部门数据
var departments = DepartmentDal.Instance.GetAll().ToList();
foreach (DataRow row in dt.Rows)
{
var row1 = row;
var dep = departments.Where(n => row1 != null && n.KeyId == (int)row1["departmentid"]);
var enumerable = dep as Department[] ?? dep.ToArray();
if (enumerable.Any())
{
row["depname"] = enumerable.First().DepartmentName;
}
else
{
row["depname"] = "";
}
var userList = users as IList <User> ?? users.ToList();
row["Departments"] = userList.First(n => n.KeyId == PublicMethod.GetInt(row["KeyId"])).Departments;
}
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public virtual List <T> GetPage(string predicate, int page, int page_size, string order, string asc, out int total)
{
//total =GetAllNoCache().Where(p=>p.IsDelete==false).Count();
//predicate= ;
return(SearchSqLFor_Page(FilterTranslator.ToSql(predicate), page, page_size, order, asc, out total));
}
