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 }