public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
try
{
if (context.Session["user"] == null)
{
context.Response.Write("noseion");
return;
}
else if (context.Request.QueryString["action"] == "search")
{
string strWhere = "1=1";
int pageindex = int.Parse(context.Request["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
string strjson = new BLL.jldl1().getJsonjldl1(pagesize, pageindex, strWhere);
context.Response.Write(strjson);
}
else if (context.Request.Params["action"] == "add")
{
Model.jldl1 model = new Model.jldl1();
model.fksj = DateTime.Now;
model.pj = context.Request.Params["pj"];
model.fssj = context.Request.Params["fssj"];
model.fsdq = context.Request.Params["fsdq"];
model.dls = context.Request.Params["dls"];
model.dlsdh = context.Request.Params["dlsdh"];
model.xlcxx = context.Request.Params["xlcxx"];
model.fknr = context.Request.Params["fknr"];
model.plga = context.Request.Params["plga"];
model.fl = context.Request.Params["fl"];
if (new BLL.jldl1().Add(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
finally
{
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
try
{
if (context.Session["user"] == null)
{
context.Response.Write("noseion");
return;
}
else if (context.Request.QueryString["action"] == "search")
{
string begindate = context.Request.Params["bdate"];
string enddate = context.Request.Params["edate"];
string chk = context.Request.Params["chk"];
string search = context.Request.Params["txt_word"];
List <string> whereList = new List <string>();
if (!string.IsNullOrEmpty(begindate) && !string.IsNullOrEmpty(enddate))
{
whereList.Add("fksj between '" + begindate + "' and '" + enddate + "'");
}
else if (string.IsNullOrEmpty(begindate) == false)
{
whereList.Add("fksj='" + begindate + "'");
}
if (chk == "true" && string.IsNullOrEmpty(search) == false)
{
whereList.Add(" (fkr like '%" + search + "%' or dls like '%" + search + "%')");
}
string strWhere = "";
string strSql = string.Join(" and ", whereList.ToArray());
if (strSql.Length > 1)
{
strWhere += strSql;
}
else
{
strWhere = "1=1";
}
int pageindex = int.Parse(context.Request["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
string strjson = new BLL.jldl1().getJsonjldl1(pagesize, pageindex, strWhere);
context.Response.Write(strjson);
}
else if (context.Request.QueryString["action"] == "query")
{
string begindate = context.Request.Params["b_date"];
string enddate = context.Request.Params["e_date"];
string chk = context.Request.Params["chk"];
string search = context.Request.Params["txt_word"];
List <string> whereList = new List <string>();
if (!string.IsNullOrEmpty(begindate) && !string.IsNullOrEmpty(enddate))
{
whereList.Add("fksj between '" + begindate + "' and '" + enddate + "' ");
}
if (chk == "true")
{
whereList.Add(" (fkr like '%'+ '" + search + "'+'%' or dls like '%'+ '" + search + "'+'%') ");
}
string whereSql = string.Join(" and ", whereList.ToArray());
string strWhere = "";
if (whereSql.Length > 0)
{
strWhere = strWhere + whereSql;
}
else
{
strWhere = "1=1";
}
int pageindex = int.Parse(context.Request["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
string strjson = new BLL.jldl1().getJsonjldl1(pagesize, pageindex, strWhere);
context.Response.Write(strjson);
}
else if (context.Request.Params["action"] == "add")
{
Model.jldl1 model = new Model.jldl1();
model.fksj = System.DateTime.Now;
model.fkr = (context.Session["user"] as YJUI.Model.ui_user).xingming;
model.pj = context.Request.Params["pj"];
model.fssj = context.Request.Params["fssj"];
model.fsdq = context.Request.Params["fsdq"];
model.dls = context.Request.Params["dls"];
model.dlsdh = context.Request.Params["dlsdh"];
model.xlcxx = context.Request.Params["xlcxx"];
model.fknr = context.Request.Params["fknr"];
model.fl = context.Request.Params["fl"];
if (new BLL.jldl1().Add(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "edit")
{
Model.jldl1 model = new Model.jldl1();
model.ID = int.Parse(context.Request.Params["ID"]);
//context.Response.Write(model);
//int id = int.Parse(context.Request.Params["ID"]);
//model = new BLL.jldl1().GetModel(id);
object obj = context.Request.Params["fksj"];
//model.fksj = Convert.ToDateTime(context.Request.Params["fksj"].ToString());
model.fkr = context.Request.Params["fkr"];
model.pj = context.Request.Params["pj"];
model.fssj = context.Request.Params["fssj"];
model.fsdq = context.Request.Params["fsdq"];
model.dls = context.Request.Params["dls"];
model.dlsdh = context.Request.Params["dlsdh"];
model.xlcxx = context.Request.Params["xlcxx"];
model.fknr = context.Request.Params["fknr"];
model.fl = context.Request.Params["fl"];
model.jjsfth = context.Request.Params["jjsfth"];
model.zrbm = context.Request.Params["zrbm"];
model.zrr = context.Request.Params["zrr"];
model.ycclrq = context.Request.Params["ycclrq"];
model.plga = context.Request.Params["plga"];
model.dkhcs = context.Request.Params["dkhcs"];
model.wcsj = context.Request.Params["wcsj"];
model.kcclcs = context.Request.Params["kcclcs"];
model.kcwcrq = context.Request.Params["kcwcrq"];
model.gysclcs = context.Request.Params["gysclcs"];
model.dsfjh = context.Request.Params["dsfjh"];
if (new BLL.jldl1().Update(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
//第三方审核
else if (context.Request.Params["action"] == "edit_dsfjh")
{
Model.jldl1 model = new Model.jldl1();
model.ID = int.Parse(context.Request.Params["ID"]);
model.fl = context.Request.Params["fl"];
model.dsfjh = context.Request.Params["dsfjh"];
if (new BLL.jldl1().Update_dsfjh(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "edit_zrbm")
{
Model.jldl1 model = new Model.jldl1();
model.ID = int.Parse(context.Request.Params["ID"]);
model.jjsfth = context.Request.Params["jjsfth"];
model.zrbm = context.Request.Params["zrbm"];
model.zrr = context.Request.Params["zrr"];
//第一次处理日期
model.ycclrq = Convert.ToString(DateTime.Now);
model.plga = context.Request.Params["plga"];
model.dkhcs = context.Request.Params["dkhcs"];
model.wcsj = context.Request.Params["wcsj"];
model.kcclcs = context.Request.Params["kcclcs"];
model.kcwcrq = context.Request.Params["kcwcrq"];
model.gysclcs = context.Request.Params["gysclcs"]; //供应商处理措施
model.gysrq = context.Request.Params["gysrq"]; //供应商完成日期
model.nblcgygs = context.Request.Params["nblcgygs"];
model.nblcwcrq = context.Request.Params["nblcwcrq"];
model.qtcs = context.Request.Params["qtcs"];
model.qtcsrq = context.Request.Params["qtcsrq"];
// model.dsfjh = context.Request.Params["dsfjh"];
if (new BLL.jldl1().Update_zrbm(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "edit_zrbmsh")
{
Model.jldl1 model = new Model.jldl1();
model.ID = int.Parse(context.Request.Params["ID"]);
model.zrbmsp = context.Request.Params["zrbmsp"];
if (new BLL.jldl1().Update_zrbmsh(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "edit_kfhf")
{
Model.jldl1 model = new Model.jldl1();
model.ID = int.Parse(context.Request.Params["ID"]);
model.hfsjqk = context.Request.Params["hfsjqk"];
model.hfwcrq = context.Request.Params["hfwcrq"];
if (new BLL.jldl1().Update_hfsjqk(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
finally
{
context.Response.End();
}
}
