public void ProcessRequest(HttpContext context)
{
//查看session
if (HttpContext.Current.Session["user"] == null)
{
context.Response.ContentType = "text/plain";
context.Response.Write("nosession");
return;
}
if ((context.Request["type"] == null) || (context.Request["data"] == null))
{
context.Response.ContentType = "text/plain";
context.Response.Write("type或data参数为空");
}
//标题
string title = "";
//传递参数
SqlParameter[] parm = new SqlParameter[1];
//存储过程名称
string ProName = "";
//获取分页及单页面数据条数限制
int totalCount = 0;
int page = 1;
int limit = 20;
if ((context.Request.QueryString["page"] != null) && (context.Request.QueryString["limit"] != null))
{
page = int.Parse(context.Request.QueryString["page"].ToString());
limit = int.Parse(context.Request.QueryString["limit"].ToString());
}
#region 学生实时预警统计(图书)
if (context.Request["data"] == "xsssyjtjts")
{
//存储过程名称
ProName = "EW_TSYJ_ByXYAndNJ";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@time", DateTime.Now.AddMonths(-12).ToString("yyyy-MM-dd"));
parm[1] = new SqlParameter("@lastestgrade", 2017);
}
#endregion
#region 学生实时预警统计(健康)
if (context.Request["data"] == "xsssyjtjjk")
{
//存储过程名称
ProName = "EW_JKYJ_ByXYAndNJ";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[1];
parm[0] = new SqlParameter("@lastestgrade", 2017);
}
#endregion
#region 学生实时预警统计(医务)
if (context.Request["data"] == "xsssyjtjyw")
{
//存储过程名称
ProName = "EW_YWYJ_ByXYAndNJ";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@time", DateTime.Now.AddMonths(-2).ToString("yyyy-MM-dd"));
parm[1] = new SqlParameter("@lastestgrade", 2017);
}
#endregion
#region 学生实时预警统计(消费)
if (context.Request["data"] == "xsssyjtj")
{
//存储过程名称
ProName = "EW_XSYJByXYAndNJ";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[3];
parm[0] = new SqlParameter("@time", "20180425");
parm[1] = new SqlParameter("@waring", 3);
parm[2] = new SqlParameter("@lastestgrade", 2017);
}
#endregion
#region 学生预警（按辅导员统计）
if (context.Request["data"] == "xsyj")
{
//存储过程名称
ProName = "EW_XSYJByFDY";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@time", "20180425");
parm[1] = new SqlParameter("@waring", 3);
}
#endregion
#region 晚归学生分布情况
if (context.Request["data"] == "wgxsfbqk")
{
//存储过程名称
ProName = "EW_WGXS";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@begintime", "20140415 22:00:00");
parm[1] = new SqlParameter("@endtime", "20140416 04:00:00");
}
#endregion
#region 预警学生详情
if (context.Request["data"] == "EWDetail")
{
//存储过程名称
ProName = "EW_StudentDetail";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[11];
parm[0] = new SqlParameter("@xh", context.Request["xh"]);
parm[1] = new SqlParameter("@xm", context.Request["xm"]);
parm[2] = new SqlParameter("@yxmc", context.Request["yxmc"]);
parm[3] = new SqlParameter("@zymc", context.Request["zymc"]);
parm[4] = new SqlParameter("@bjmc", context.Request["bjmc"]);
parm[5] = new SqlParameter("@time", context.Request["time"]);
parm[6] = new SqlParameter("@warning", context.Request["warning"]);
parm[7] = new SqlParameter("@fdy", context.Request[("fdy")]);
parm[8] = new SqlParameter("@page_size", limit);
parm[9] = new SqlParameter("@page_num", page);
parm[10] = new SqlParameter("@total_record", SqlDbType.Int);
parm[10].Direction = ParameterDirection.Output;
}
#endregion
//运行SQL
DataSet dt = DBUtility.ProceureToTable(ProName, parm);
if (context.Request["data"] == "EWDetail")
{
totalCount = Convert.ToInt32(parm[10].Value);
}
#region 输出图形分成几份
int count = 0;
//分成几份传参
if (context.Request["count"] != null)
{
int.TryParse(context.Request["count"], out count);
}
else if (dt.Tables[0] != null)
{
count = dt.Tables[0].Rows.Count;
}
#endregion
#region 生成前台使用数据
//生成柱状图数据---type=column
if (context.Request["type"] == "column")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToColumnJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成饼图数据---type=pie
if (context.Request["type"] == "pie")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToPieJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成表格所需数据---type=table
if (context.Request["type"] == "table")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "]}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//分页生成表格所需数据---type=tablepaged
if (context.Request["type"] == "tablepaged")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "],";
str += "totalCount:" + "'" + totalCount.ToString() + "'" + "}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//导出表格数据到Excel---type=export_excel
if (context.Request["type"] == "export_excel")
{
ExportClass.DataGridViewExportToExcel(dt, title);
}
#endregion
}
public void ProcessRequest(HttpContext context)
{
//查看session
if (HttpContext.Current.Session["user"] == null)
{
context.Response.ContentType = "text/plain";
context.Response.Write("nosession");
return;
}
if ((context.Request["type"] == null) || (context.Request["data"] == null))
{
context.Response.ContentType = "text/plain";
context.Response.Write("type或data参数为空");
}
//标题
string title = "";
//传递参数
SqlParameter[] parm = new SqlParameter[1];
//存储过程名称
string ProName = "";
//初始化检索
int datecount = 7;
//初始化时间
DateTime endtime = DateTime.Now.AddDays(-1);
DateTime begtime = endtime;
if (context.Request["time"] != null)
{
if (context.Request["time"] == "一周")
{
datecount = 7;
}
else if (context.Request["time"] == "两周")
{
datecount = 14;
}
else if (context.Request["time"] == "一月")
{
datecount = 30;
}
else if (context.Request["time"] == "一年")
{
datecount = 366;
}
begtime = endtime.AddDays(-datecount);
}
if ((context.Request["begtime"] != null) && (context.Request["endtime"] != null))
{
begtime = DateTime.Parse(context.Request["begtime"].ToString());
endtime = DateTime.Parse(context.Request["endtime"].ToString());
datecount = (endtime - begtime).Days;
}
//获取分页及单页面数据条数限制
int totalCount = 0;
int page = 1;
int limit = 20;
if ((context.Request.QueryString["page"] != null) && (context.Request.QueryString["limit"] != null))
{
page = int.Parse(context.Request.QueryString["page"].ToString());
limit = int.Parse(context.Request.QueryString["limit"].ToString());
}
#region 馆藏图书按中图法分类
if (context.Request["data"] == "ztf")
{
//存储过程名称
ProName = "Library_ZTF";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[0];
}
#endregion
#region 馆藏图书按类型分类
if (context.Request["data"] == "lx")
{
//存储过程名称
ProName = "Library_LX";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[0];
}
#endregion
#region 图书借阅分学院统计
if (context.Request["data"] == "tsjybyxy")
{
//存储过程名称
ProName = "Library_JYByXY";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@begintime", "20170101");
parm[1] = new SqlParameter("@endtime", "20180417");
}
#endregion
#region 图书利用率统计
if (context.Request["data"] == "tslyl")
{
//存储过程名称(需要注意在哪个用户下)
if (context.Request["type"] == "column")
{
ProName = "Library_TSLYL_Chart";
}
if ((context.Request["type"] == "table") || (context.Request["type"] == "export_excel"))
{
ProName = "Library_TSLYL_Tab";
}
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[2];
parm[0] = new SqlParameter("@begintime", begtime.ToString("yyyyMMdd"));
parm[1] = new SqlParameter("@endtime", endtime.ToString("yyyyMMdd"));
}
#endregion
#region 热点图书
if (context.Request["data"] == "rdts")
{
//存储过程名称(需要注意在哪个用户下)
if (context.Request["type"] == "column")
{
ProName = "Library_RDTS_Chart";
}
if ((context.Request["type"] == "table") || (context.Request["type"] == "export_excel"))
{
ProName = "Library_RDTS_Tab";
}
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[3];
int top = 10;
parm[0] = new SqlParameter("@top", top);
if ((context.Request["top"] != null) && (int.TryParse(context.Request["top"], out top)))
{
parm[0].Value = top;
}
else
{
parm[0].Value = 10;
}
parm[1] = new SqlParameter("@begintime", begtime.ToString("yyyyMMdd"));
parm[2] = new SqlParameter("@endtime", endtime.ToString("yyyyMMdd"));
}
#endregion
#region 图书借阅详情
if (context.Request["data"] == "BorrowDetail")
{
//存储过程名称(需要注意在哪个用户下)
ProName = "Library_BorrowDetail";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[11];
parm[0] = new SqlParameter("@begintime", begtime.ToString("yyyyMMdd"));
parm[1] = new SqlParameter("@endtime", endtime.ToString("yyyyMMdd"));
parm[2] = new SqlParameter("@xh", context.Request["iv_id"]);
parm[3] = new SqlParameter("@xm", context.Request["iv_name"]);
parm[4] = new SqlParameter("@xy", context.Request["iv_department"]);
parm[5] = new SqlParameter("@title", context.Request["iv_book_name"]);
parm[6] = new SqlParameter("@author", context.Request[("iv_author")]);
parm[7] = new SqlParameter("@isbn", context.Request["iv_ISBN"]);
parm[8] = new SqlParameter("@page_size", limit);
parm[9] = new SqlParameter("@Page_num", page);
parm[10] = new SqlParameter("@total_record", SqlDbType.Int);
parm[10].Direction = ParameterDirection.Output;
}
#endregion
//运行SQL
DataSet dt = DBUtility.ProceureToTable(ProName, parm);
if (context.Request["data"] == "BorrowDetail")
{
totalCount = Convert.ToInt32(parm[10].Value);
}
#region 输出图形分成几份
int count = 0;
//分成几份传参
if (context.Request["count"] != null)
{
int.TryParse(context.Request["count"], out count);
}
else if (dt.Tables[0] != null)
{
count = dt.Tables[0].Rows.Count;
}
#endregion
#region 生成前台使用数据
//生成柱状图数据---type=column
if (context.Request["type"] == "column")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToColumnJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成饼图数据---type=pie
if (context.Request["type"] == "pie")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToPieJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成表格所需数据---type=table
if (context.Request["type"] == "table")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "]}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//分页生成表格所需数据---type=tablepaged
if (context.Request["type"] == "tablepaged")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "],";
str += "totalCount:" + "'" + totalCount.ToString() + "'" + "}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//导出表格数据到Excel---type=export_excel
if (context.Request["type"] == "export_excel")
{
ExportClass.DataGridViewExportToExcel(dt, title);
}
#endregion
}
public void ProcessRequest(HttpContext context)
{
//查看session
if (HttpContext.Current.Session["user"] == null)
{
context.Response.ContentType = "text/plain";
context.Response.Write("nosession");
return;
}
if ((context.Request["type"] == null) || (context.Request["data"] == null))
{
context.Response.ContentType = "text/plain";
context.Response.Write("type或data参数为空");
}
//标题
string title = "";
//传递参数
SqlParameter[] parm = new SqlParameter[1];
//存储过程名称
string ProName = "";
//初始化检索
int datecount = 7;
//初始化时间
DateTime endtime = DateTime.Now.AddDays(-1);
DateTime begtime = endtime;
if (context.Request["time"] != null)
{
if (context.Request["time"] == "一周")
{
datecount = 7;
}
else if (context.Request["time"] == "两周")
{
datecount = 14;
}
else if (context.Request["time"] == "一月")
{
datecount = 30;
}
else if (context.Request["time"] == "一年")
{
datecount = 366;
}
begtime = endtime.AddDays(-datecount);
}
if ((context.Request["begtime"] != null) && (context.Request["endtime"] != null))
{
begtime = DateTime.Parse(context.Request["begtime"].ToString());
endtime = DateTime.Parse(context.Request["endtime"].ToString());
datecount = (endtime - begtime).Days;
}
//获取分页及单页面数据条数限制
int totalCount = 0;
int page = 1;
int limit = 20;
if ((context.Request.QueryString["page"] != null) && (context.Request.QueryString["limit"] != null))
{
page = int.Parse(context.Request.QueryString["page"].ToString());
limit = int.Parse(context.Request.QueryString["limit"].ToString());
}
#region 用户信息详情
if (context.Request["data"] == "CustomerDetail")
{
//存储过程名称(需要注意在哪个用户下)
ProName = "Card_CustomerDetail";
//具体申请几个空间看存储过程中需要几个参数
parm = new SqlParameter[10];
parm[0] = new SqlParameter("@stuempno", context.Request["stuempno"]);
parm[1] = new SqlParameter("@custname", context.Request["custname"]);
parm[2] = new SqlParameter("@sex", context.Request["sex"]);
parm[3] = new SqlParameter("@custtypename", context.Request["custtypename"]);
parm[4] = new SqlParameter("@idno", context.Request["idno"]);
parm[5] = new SqlParameter("@deptname", context.Request["deptname"]);
parm[6] = new SqlParameter("@classname", context.Request[("classname")]);
parm[7] = new SqlParameter("@page_size", limit);
parm[8] = new SqlParameter("@Page_num", page);
parm[9] = new SqlParameter("@total_record", SqlDbType.Int);
parm[9].Direction = ParameterDirection.Output;
}
#endregion
//运行SQL
DataSet dt = DBUtility.ProceureToTable(ProName, parm);
if (context.Request["data"] == "CustomerDetail")
totalCount = Convert.ToInt32(parm[9].Value);
#region 输出图形分成几份
int count = 0;
//分成几份传参
if (context.Request["count"] != null)
{
int.TryParse(context.Request["count"], out count);
}
else if (dt.Tables[0] != null)
{
count = dt.Tables[0].Rows.Count;
}
#endregion
#region 生成前台使用数据
//生成柱状图数据---type=column
if (context.Request["type"] == "column")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToColumnJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成饼图数据---type=pie
if (context.Request["type"] == "pie")
{
context.Response.ContentType = "text/plain";
context.Response.Write(DataSetConvertJson.TransformToPieJson(dt, DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd"), count, title));
}
//生成表格所需数据---type=table
if (context.Request["type"] == "table")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "]}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//分页生成表格所需数据---type=tablepaged
if (context.Request["type"] == "tablepaged")
{
string str = "{\"items\":[" + DataSetConvertJson.DataTable2Json(dt.Tables[0]) + "],";
str += "totalCount:" + "'" + totalCount.ToString() + "'" + "}";
context.Response.ContentType = "text/plain";
context.Response.Write(str);
}
//导出表格数据到Excel---type=export_excel
if (context.Request["type"] == "export_excel")
{
ExportClass.DataGridViewExportToExcel(dt, title);
}
#endregion
}
