public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//判断登陆
Models.Admin.Dt_User user = App_Code.RoleFuns.IsLoginAdmin(context.Session["user"]);
if (user == null)
{
var tempResult = new { IsSuccess = false, Message = "您未登录，或登录超时，请登录后操作" };
context.Response.Write(JsonConvert.SerializeObject(tempResult));
return;
}
string type = context.Request.Form["type"].Trim();
if (type == "add")
{
Add(context);
}
else if (type == "list")
{
List(context);
}
else if (type == "det")
{
Det(context);
}
else if (type == "upt")
{
Upt(context);
}
else if (type == "single")
{
Single(context);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//判断登陆
Models.Admin.Dt_User user = App_Code.RoleFuns.IsLoginAdmin(context.Session["user"]);
if (user == null)
{
var tempResult = new { IsSuccess = false, Message = "您未登录，或登录超时，请登录后操作" };
context.Response.Write(JsonConvert.SerializeObject(tempResult));
return;
}
// 各个参数
int id = Convert.ToInt32(context.Request.QueryString["id"]);
int pageIndex = Convert.ToInt32(context.Request.Form["PageIndex"]);
int pageSize = Convert.ToInt32(context.Request.Form["PageSize"]);
string where = context.Request.Form["Where"];
// 获取自定义表单数据库内容
var model = DAL.CustomFormDal.GetCustomFormDAL.GetSingleCustomForm(id, false);
// 获取查询字段,替换SQLwhere条件值
if (!string.IsNullOrWhiteSpace(where))
{
var fields = JsonConvert.DeserializeObject <List <entity.Fields> >(model.Fields);
var whereDic = JsonConvert.DeserializeObject <IDictionary <string, string> >(where);
foreach (var f in fields)
{
if (f.isShow)
{
model.SQL = model.SQL.Replace(f.field, whereDic.FirstOrDefault(k => k.Key == f.field).Value);
}
else
{
model.SQL = model.SQL.Replace(f.field, f.defaultValue);
}
}
}
// 获取数据源
int recordcount = 0, pagecount = 0;
DataSet dataset = DAL.CustomFormDal.GetCustomFormDAL.GetCustomSQLData(model.SQL, pageIndex, pageSize, ref recordcount, ref pagecount);
pagecount = pagecount == 0 ? 1 : pagecount;
// 组装数据td
DataTable data = dataset.Tables[1];
var datalist = new { data = data, total = recordcount, pagecount = pagecount, IsSuccess = true, Message = "获取成功" };
string result = JsonConvert.SerializeObject(datalist);
// 输出
context.Response.Write(result);
}
