public bool Insert(Model.ui_tuji model)
{
using (SqlConnection conn = new SqlConnection(ConnStrManage.NEWV2013DB))
{
return(conn.Execute(INSERT, model) > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Zhuanxiang_add(Model.ui_tuji model)
{
string sql = @"update ui_tuji
set [zx_look] = @zx_look,[zx_is] = @zx_is where ID=@ID";
using (SqlConnection conn = new SqlConnection(ConnStrManage.NEWV2013DB))
{
return(conn.Execute(sql, model) > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Kefu_add(Model.ui_tuji model)
{
string sql = @"update ui_tuji
set
[service]=@service
,[service_date] = @service_date
where ID=@ID";
using (SqlConnection conn = new SqlConnection(ConnStrManage.NEWV2013DB))
{
return(conn.Execute(sql, model) > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Houtai_add(Model.ui_tuji model)
{
string sql = @"update ui_tuji
set
[ht_dep] = @ht_dep
,[ht_person] = @ht_person
,[ht_lqdate]=@ht_lqdate
,[ht_predate]=@ht_predate
,[ht_status]=@ht_status
where ID=@ID";
using (SqlConnection conn = new SqlConnection(ConnStrManage.NEWV2013DB))
{
return(conn.Execute(sql, model) > 0);
}
}
public bool Kefu_add(Model.ui_tuji model)
{
return(dal.Kefu_add(model));
}
public bool Houtai_add(Model.ui_tuji model)
{
return(dal.Houtai_add(model));
}
public bool Zhuanxiang_add(Model.ui_tuji model)
{
return(dal.Zhuanxiang_add(model));
}
public bool Insert(Model.ui_tuji model)
{
return(dal.Insert(model));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (context.Session["user"] == null)
{
context.Response.Write("nosession");
context.Response.End();
}
else if (context.Request.QueryString["action"] == "search")
{
var type = context.Request.Params["type"];
var bdate = context.Request.Params["bdate"];
var edate = context.Request.Params["edate"];
var fk_person = context.Request.Params["fk_person"];
var strjson = new BLL.ui_tuji().ToJson(bdate, edate, fk_person, type);
context.Response.Write(strjson);
}
else if (context.Request.Params["action"] == "add")
{
Model.ui_tuji model = new Model.ui_tuji();
model.fk_date = DateTime.Now;
model.fk_person = (context.Session["user"] as YJUI.Model.ui_user).xingming;
model.fk_dep = (context.Session["user"] as YJUI.Model.ui_user).depname;
model.fk_area = context.Request.Params["fk_area"];
model.fk_customer = context.Request.Params["fk_customer"];
model.fk_type = context.Request.Params["fk_type"];
model.fk_dec = context.Request.Params["fk_dec"];
if (new BLL.ui_tuji().Insert(model))
{
context.Response.Write("ok");
}
}
else if (context.Request.Params["action"] == "zhuanxiang_add")
{
Model.ui_tuji model = new Model.ui_tuji();
model.ID = int.Parse(context.Request.Params["ID"]);
model.zx_look = context.Request.Params["zx_look"];
model.zx_is = context.Request.Params["zx_is"];
if (new BLL.ui_tuji().Zhuanxiang_add(model))
{
context.Response.Write("ok");
}
}
else if (context.Request.Params["action"] == "houtai_add")
{
Model.ui_tuji model = new Model.ui_tuji();
model.ID = int.Parse(context.Request.Params["ID"]);
model.ht_dep = context.Request.Params["ht_dep"];
model.ht_person = context.Request.Params["ht_person"];
model.ht_lqdate = DateTime.Now;
model.ht_predate = DateTime.Parse(context.Request.Params["ht_predate"]);
model.ht_status = context.Request.Params["ht_status"];
if (new BLL.ui_tuji().Houtai_add(model))
{
context.Response.Write("ok");
}
}
else if (context.Request.Params["action"] == "kefu_add")
{
Model.ui_tuji model = new Model.ui_tuji();
model.ID = int.Parse(context.Request.Params["ID"]);
model.service = context.Request.Params["service"];
model.service_date = DateTime.Parse(context.Request.Params["service_date"]);
if (new BLL.ui_tuji().Kefu_add(model))
{
context.Response.Write("ok");
}
}
#region 导出
if (context.Request.Params["action"] == "export")
{
string strWhere = "1=1 ";
var type = context.Request.Params["type"];
var bdate = context.Request.Params["bdate"];
var edate = context.Request.Params["edate"];
DataSet ds = new BLL.ui_tuji().GetReport(NewMethod1(strWhere, type, bdate, edate));
string str = "序号,反馈时间,反馈人,反馈部门,反馈地区,反馈客户,问题类型,反馈描述,专项调查,真问题呈现,后台支持团队,对接人员,领取时间,预计完成时间,问题处理状态,反馈客户,客服反馈给客户时间";
Common.NpoiHelper.ToExcelByNpoi(ds.Tables[0], str);
}
#endregion
}
