protected void Page_Load(object sender, EventArgs e)
{
if (!SysVisitor.Instance.IsGuest)
{
string fields = PublicMethod.GetString(Request["fields"]);
string filters = PublicMethod.GetString(Request["filters"]);
string tableName = PublicMethod.GetString(Request["tableName"]);
var pcp = new ProcCustomPage(tableName)
{
ShowFields = fields,
PageIndex = 1,
PageSize = 9999999,
OrderFields = "",
WhereString = FilterTranslator.ToSql(filters)
};
int recordCount;
DataTable dt = DbUtils.GetPageWithSp(pcp, out recordCount);
GridViewExportUtil.Export(DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls", dt);
}
else
{
Response.Write("<h1>没有登录啊，你懂的！</h1>");
}
}
private string JsonDataForEasyUIdataGrid2(int pageindex, int pagesize, string filterJSON)
{
string where = string.Empty;
if (filterJSON != "")
{
where = FilterTranslator.ToSql(filterJSON);
}
else
{
where = " ";
}
var pcp = new ProcCustomPage()
{
Sp_PagerName = "ProcCustomPageUnion",
TableName = @"(select a.ID, a.BookName, a.BookSNCode, a.BookPrice, a.PressID, PressName, PressAddress, PressPhone
from BookInfo a inner join PressInfo b on a.PressID= b.ID)",
PageIndex = pageindex,
PageSize = pagesize,
ShowFields = "*",
OrderFields = "ID desc",
KeyFields = "ID",
WhereString = where
};
int recordCount;
DataTable dt = DbUtils.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "keyid", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage("sys_roles")
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = sortorder,
WhereString = FilterTranslator.ToSql(filterJson)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
dt.Columns.Add(new DataColumn("Departments")); //可以访问的部门数据
var rolelist = RoleDal.Instance.GetAll();
foreach (DataRow row in dt.Rows)
{
row["Departments"] = rolelist.First(n => n.KeyId == PublicMethod.GetInt(row["KeyId"])).Departments;
}
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
private string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJSON)
{
//数据权限条件
int userid = SysVisitor.Instance.UserId;
string deps = SysVisitor.Instance.Departments;
string where = "ownner=" + userid + " and depid in (" + deps + ")";
if (SysVisitor.Instance.IsAdmin)
{
where = "";
}
else
{
if (filterJSON != "")
{
where = FilterTranslator.ToSql(filterJSON) + " and " + where;
}
}
var pcp = new ProcCustomPage("demo_users")
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = "keyid asc",
WhereString = where
};
int recordCount;
DataTable dt = DbUtils.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public string GetJsonData(int pageindex, int pagesize, string filterJson, string sort, string order)
{
var pcp = new ProcCustomPage("base_Employee")
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = sort + " " + order,
SQL_WHERE_IN = FilterTranslator.ToSql(filterJson)
};
var Employees = EmployeeDal.Instance.GetAll();
int recordCount;
DataTable dt = EmployeeDal.Instance.GetPageWithSp(pcp, out recordCount);
dt.Columns.Add(new DataColumn("DepartmentName"));
var departments = DepartmentDal.Instance.GetAll().ToList();
foreach (DataRow row in dt.Rows)
{
var dep = departments.Where(n => row != null && n.FID == (string)row["FDepartmentID"]);
var enumerable = dep as Department[] ?? dep.ToArray();
if (enumerable.Any())
{
row["DepartmentName"] = enumerable.First().DepartmentName;
}
else
{
row["DepartmentName"] = "";
}
}
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage("sys_roles")
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = sortorder.Trim(),
SQL_WHERE_IN = FilterTranslator.ToSql(filterJson)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
dt.Columns.Add(new DataColumn("Departments")); //可以访问的部门数据
var rolelist = RoleDal.Instance.GetAll();
foreach (DataRow row in dt.Rows)
{
row["Departments"] = rolelist.First(n => n.FID == PublicMethod.GetString(row["FID"])).Departments;
}
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public override DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
//if (SysVisitor.Instance.CurrentUser != null && SysVisitor.Instance.CurrentUser.ORGANIZE_NAME != "总部")
//{
// pcp.SQL_WHERE_IN += string.Format(" AND ORGANIZE_ID='{0}'", SysVisitor.Instance.CurrentUser.ORGANIZE_ID);
//}
pcp.SQL_WHERE_IN += Where;
return(DbUtils.GetPageWithSp(pcp, out recordCount));
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJSON)
{
var pcp = new ProcCustomPage("V_logs")
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = "FID desc",
SQL_WHERE_IN = FilterTranslator.ToSql(filterJSON)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJSON)
{
var pcp = new ProcCustomPage("V_logs")
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = "keyid desc",
WhereString = FilterTranslator.ToSql(filterJSON)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public override DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
DataTable table = base.GetPageWithSp(pcp, out recordCount);
if (pcp.IDX_PAGE_IN == 1)
{
DataRow newRow = table.NewRow();
newRow["FID"] = "0";
newRow["NAME"] = "总部";
table.Rows.InsertAt(newRow, 0);
}
return(table);
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "FID", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage("sys_buttons")
{
IDX_PAGE_IN = pageindex,
CURR_PAGE_COUNT_IN = pagesize,
SQL_ORDERBY_IN = sortorder,
SQL_WHERE_IN = FilterTranslator.ToSql(filterJson)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJson, string sort = "keyid", string order = "asc")
{
string sortorder = sort + " " + order;
var pcp = new ProcCustomPage("sys_roles")
{
PageIndex = pageindex,
PageSize = pagesize,
OrderFields = sortorder,
WhereString = FilterTranslator.ToSql(filterJson)
};
int recordCount;
DataTable dt = base.GetPageWithSp(pcp, out recordCount);
return(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt));
}
public override DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
if (_platformid != "")
{
if (pcp.SQL_WHERE_IN == "")
{
pcp.SQL_WHERE_IN = "(ID IN (" + _platformid + "))";
}
else
{
pcp.SQL_WHERE_IN = pcp.SQL_WHERE_IN + " AND (ID IN (" + _platformid + "))";
}
}
DataTable table = base.GetPageWithSp(pcp, out recordCount);
return(table);
}
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));
}
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));
}
