public void ProcessRequest(HttpContext context)
{
try
{
//if (context.Session["user"]==null)
//{
// // context.Response.Write("nosession");
// context.Response.Write("{\"msg\": \"nosession\"}");
// context.Response.End();
//}
#region 查询
if (context.Request.QueryString["action"] == "search")
{
string strWhere = "1=1 ";
string bdate = context.Request.Params["bdate"];
string edate = context.Request.Params["edate"];
string word = context.Request.Params["fkPerson"];
string dep = context.Request.Params["txt_dep"]; //反馈部门
string par = context.Request.Params["params"]; //local
JObject obj = JObject.Parse(par); //解析成其他；
var username = obj.Value <string>("userName");
var pwd = obj.Value <string>("pwd");
var fkItem = context.Request.Params["fkItem"]; //反馈部门
strWhere = NewMethod(strWhere, bdate, edate, word, dep, fkItem);
int pageindex = int.Parse(context.Request["page"]);
int pagesize = 5;
string strjson = new BLL.neibutaizhang().GetJsonneibuTaizhang(pagesize, pageindex, strWhere);
context.Response.Write(strjson);
}
#endregion
#region 添加
else if (context.Request.Params["action"] == "add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.fkDate = DateTime.Parse(DateTime.Now.ToShortDateString());
string par = context.Request.Params["params"]; //local
JObject obj = JObject.Parse(par); //解析成其他；
var username = obj.Value <string>("userName");
var pwd = obj.Value <string>("pwd");
Model.ui_user Loginer = new BLL.ui_user().Login(username, pwd);//登录验证
model.fkPerson = Loginer.xingming;
model.FkDep = Loginer.depname;
model.wtDep = context.Request.Params["wtDep"];
model.fkItem = context.Request.Params["fkItem"];
model.fkDesc = context.Request.Params["fkDesc"];
model.fkArea = context.Request.Params["fkArea"];
model.fkCustomer = context.Request.Params["fkCustomer"];
if (new BLL.neibutaizhang().Add(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
#endregion
#region 问题处理添加
else if (context.Request.Params["action"] == "wentichuli_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.dyDep = context.Request.Params["dyDep"];
model.dyPerson = context.Request.Params["dyPerson"];
string dyDate = context.Request.Params["dyDate"];
model.dyDate = DateTime.Parse(dyDate);
model.dyGaishan = context.Request.Params["dyGaishan"];
model.cqFangan = context.Request.Params["cqFangan"];
model.cqDate = Convert.ToDateTime(context.Request.Params["cqDate"]);
if (new BLL.neibutaizhang().Update(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
#endregion
else if (context.Request.Params["action"] == "luoshijianhe_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.lsDep = context.Request.Params["lsDep"];
model.lsJianhe = context.Request.Params["lsJianhe"];
string lsdate = context.Request.Params["lsDate"];
model.lsDate = DateTime.Parse(lsdate);
if (new BLL.neibutaizhang().Update_luoshijianhe(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "manyidupingjia_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.myPingjia = context.Request.Params["myPingjia"];
model.myPerson = context.Request.Params["myPerson"];
string mydate = context.Request.Params["myDate"];
model.myDate = DateTime.Parse(mydate);
if (new BLL.neibutaizhang().Update_manyidudiaocha(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "disanfangjianhe_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.dsJianhe = context.Request.Params["dsJianhe"];
model.dsPerson = context.Request.Params["dsPerson"];
string dsdate = context.Request.Params["dsDate"];
model.dsDate = DateTime.Parse(dsdate);
if (new BLL.neibutaizhang().Update_disanfangjianhe(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
}
catch (Exception ex)
{
context.Response.Write(ex);
}
finally
{
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
try
{
if (context.Session["user"] == null)
{
context.Response.Write("nosession");
return;
}
#region 查询
else if (context.Request.QueryString["action"] == "search")
{
string strWhere = "1=1 ";
string bdate = context.Request.Params["bdate"];
string edate = context.Request.Params["edate"];
string word = context.Request.Params["txt_search"];
string depcat = context.Request.Params["DepCat"]; //反馈部门
string dep = context.Request.Params["txt_dep"]; //反馈部门
var fkItem = context.Request.Params["fkItem"]; //反馈部门
strWhere = NewMethod(strWhere, bdate, edate, word, dep, fkItem, depcat);
int pageindex = int.Parse(context.Request["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
string strjson = new BLL.neibutaizhang().GetJsonneibuTaizhang(pagesize, pageindex, strWhere);
context.Response.Write(strjson);
}
#endregion
#region 添加
else if (context.Request.Params["action"] == "add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.fkDate = DateTime.Parse(DateTime.Now.ToShortDateString());
model.fkPerson = (context.Session["user"] as YJUI.Model.ui_user).xingming;
model.FkDep = (context.Session["user"] as YJUI.Model.ui_user).depname;
model.DepCat = context.Request.Params["DepCat"];
model.wtDep = context.Request.Params["wtDep"];
model.fkItem = context.Request.Params["fkItem"];
model.fkDesc = context.Request.Params["fkDesc"];
model.fkArea = context.Request.Params["fkArea"];
string pics = context.Request.Params["pics"];//
List <string> list = new JavaScriptSerializer().Deserialize <List <string> >(pics);
StringBuilder sb = new StringBuilder();
foreach (var item in list)
{
string[] img_array = item.Split(',');
byte[] arr = Convert.FromBase64String(img_array[1]);
string filePath = "../UploadFile";
string name = DateTime.Now.ToString("yyyyMMddHHmmssffff");
string file_name = HttpContext.Current.Server.MapPath(filePath + "/" + name);
using (MemoryStream ms = new MemoryStream(arr))
{
Bitmap bmp = new Bitmap(ms);
if (img_array[0].ToLower() == "data:image/jpeg;base64")
{
bmp.Save(file_name + ".jpg");
sb.Append(name + ".jpg" + ",");
}
else if (img_array[0].ToLower() == "data:image/png;base64")
{
bmp.Save(file_name + ".png");
sb.Append(name + ".png" + ",");
}
}
}
model.FkPic = sb.ToString();
model.fkCustomer = context.Request.Params["fkCustomer"];
if (new BLL.neibutaizhang().Add(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
#endregion
#region 问题处理添加
else if (context.Request.Params["action"] == "wentichuli_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.dyDep = context.Request.Params["dyDep"];
model.dyPerson = context.Request.Params["dyPerson"];
string dyDate = context.Request.Params["dyDate"];
model.dyDate = DateTime.Parse(dyDate);
model.IsEnd = context.Request.Params["IsEnd"];
model.dyGaishan = context.Request.Params["dyGaishan"];
model.cqFangan = context.Request.Params["cqFangan"];
model.cqDate = Convert.ToDateTime(context.Request.Params["cqDate"]);
if (new BLL.neibutaizhang().Update(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
#endregion
else if (context.Request.Params["action"] == "luoshijianhe_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.lsDep = context.Request.Params["lsDep"];
model.lsJianhe = context.Request.Params["lsJianhe"];
string lsdate = context.Request.Params["lsDate"];
model.lsDate = DateTime.Parse(lsdate);
if (new BLL.neibutaizhang().Update_luoshijianhe(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "manyidupingjia_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.myPingjia = context.Request.Params["myPingjia"];
model.myPerson = context.Request.Params["myPerson"];
string mydate = context.Request.Params["myDate"];
model.myDate = DateTime.Parse(mydate);
if (new BLL.neibutaizhang().Update_manyidudiaocha(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "disanfangjianhe_add")
{
Model.neibutaizhang model = new Model.neibutaizhang();
model.ID = int.Parse(context.Request.Params["ID"]);
model.dsJianhe = context.Request.Params["dsJianhe"];
model.dsPerson = context.Request.Params["dsPerson"];
string dsdate = context.Request.Params["dsDate"];
model.dsDate = DateTime.Parse(dsdate);
if (new BLL.neibutaizhang().Update_disanfangjianhe(model))
{
context.Response.Write("ok");
}
else
{
context.Response.Write("err");
}
}
else if (context.Request.Params["action"] == "daochu")
{
string sqlWhere = " 1=1";
string p = context.Request.Params["params"];
Dictionary <string, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, object> >(p);
var bdate = dic["bdate"].ToString();
var fkItem = dic["fkItem"].ToString();
var DepCat = dic["DepCat"].ToString();
var word = dic["txt_search"].ToString();
var edate = dic["edate"].ToString();
var dep = dic["txt_dep"].ToString();
sqlWhere = NewMethod(sqlWhere, bdate, edate, word, dep, fkItem, DepCat);//查询条件
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet1 = workbook.CreateSheet("sheet1");
IDataReader reader = new BLL.neibutaizhang().neiBuTaiZhangGetList(sqlWhere);
IRow rowhead = sheet1.CreateRow(0);
//循环表头
//fkArea,fkCustomer,
//strSql.Append("select ID,fkDate,fkPerson,fkDep,fkItem,fkArea,fkCustomer,wtDep,fkDesc,
//dyDep,dyPerson,dyDate,dyGaishan,cqFangan,cqDate,
//lsJianhe,lsDep,lsDate,
//myPingjia,myPerson,myDate,
//dsJianhe,dsPerson,dsDate ");
string cs = "序号,反馈时间,反馈人,反馈部门,所属项目,反馈地区,反馈客户,问题部门,反馈描述," +
"领取部门,领取人,领取时间,临时改善,长期方案,长期时间," +
"落实检核,落实部门,落实时间," +
"满意评价,满意人,满意时间," +
"第三方检核,检核人,检核时间";
string[] str = cs.Split(',');
for (int i = 0; i < str.Length; i++)
{
rowhead.CreateCell(i, CellType.String).SetCellValue(str[i]);
}
int index = 1;
while (reader.Read())
{
IRow rowbody = sheet1.CreateRow(index);
for (int i = 0; i < reader.FieldCount; i++)
{
ICell cellbody = rowbody.CreateCell(i);
cellbody.SetCellValue(reader[i].ToString());
}
index++;
}
//导出操作
MemoryStream ms = new MemoryStream();
workbook.Write(ms);
string title = "报表";
context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", HttpUtility.UrlEncode(title + "_" + DateTime.Now.ToString("yyyy-MM-dd"), System.Text.Encoding.UTF8)));
context.Response.BinaryWrite(ms.ToArray());
context.Response.End();
workbook = null;
ms.Close();
ms.Dispose();
}
}
catch (Exception ex)
{
context.Response.Write(ex);
}
finally
{
context.Response.End();
}
}
