protected void btnImport_Click(object sender, ImageClickEventArgs e) { try { string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "asc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_d")) { order = "desc";//排序:降序 } string ord = " ORDER BY " + orderBy + " " + order; CustComplainModel CustComplainM = new CustComplainModel(); string CustID = hiddCustID.Value; //客户ID CustComplainM.ComplainType = Convert.ToInt32(ddlComplainType.SelectedItem.Value); //投诉类型 CustComplainM.Critical = seleCritical.Value; //紧急程度 string ComplainBegin = txtComplainBegin.Value.Trim(); //投诉开始时间 string ComplainEnd = txtComplainEnd.Value.Trim(); //结束时间 CustComplainM.Title = txtTitle.Value.Trim(); //客户投诉主题 string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人 string DestClerk = txtEmplNameL.Value.Trim(); //接待人 CustComplainM.State = seleState.Value; //状态 CustComplainM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString(); DataTable dt = ComplainBus.ExportComplainInfo(CanUserID, CustID, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, ord); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "投诉单编号", "投诉主题", "客户名称", "投诉时间", "投诉分类", "紧急程度", "接待人", "处理状态" }, new string[] { "ComplainNo", "title", "custNam", "ComplainDate", "typename", "Critical", "EmployeeName", "state" }, "客户投诉列表"); } catch { ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>"); } }
public static DataTable GetCustComplainByCustID(CustComplainModel CustComplainM, int pageIndex, int pageCount, string ord, ref int TotalCount) { return(CustCallDBHelper.GetCustComplainByCustID(CustComplainM, pageIndex, pageCount, ord, ref TotalCount)); }
/// <summary> /// 导出客户投诉信息 /// </summary> /// <param name="CustID"></param> /// <param name="CustComplainM"></param> /// <param name="ComplainBegin"></param> /// <param name="ComplainEnd"></param> /// <param name="CustLinkMan"></param> /// <param name="DestClerk"></param> /// <param name="ord"></param> /// <returns></returns> public static DataTable ExportComplainInfo(string CanUserID, string CustID, CustComplainModel CustComplainM, string ComplainBegin, string ComplainEnd, string CustLinkMan, string DestClerk, string ord) { return(ComplainDBHelper.ExportComplainInfo(CanUserID, CustID, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, ord)); }
/// <summary> /// 修改客户投诉信息的方法 /// </summary> /// <param name="CustComplainM">客户投诉信息</param> /// <returns>操作结果</returns> public static bool UpdateComplain(CustComplainModel CustComplainM) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; LogInfoModel logModel = new LogInfoModel(); //操作日志 bool isSucc = false; //定义返回变量 #region 设置操作日志内容 //设置公司代码 logModel.CompanyCD = userInfo.CompanyCD; //设置登陆用户ID logModel.UserID = userInfo.UserID; //设置模块ID 模块ID在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_CUST_COMPLAIN_LIST; //操作单据编号 投诉单编号 logModel.ObjectID = CustComplainM.ComplainNo; //操作对象 操作的表信息 logModel.ObjectName = ConstUtil.TABLE_NAME_COMPLAIN; //涉及关键元素 涉及其他业务、表关系 logModel.Element = string.Empty; //备注 操作类型 logModel.Remark = ConstUtil.LOG_PROCESS_UPDATE; #endregion try { isSucc = ComplainDBHelper.UpdateComplain(CustComplainM); } catch (System.Exception ex) { #region 操作失败时记录日志到文件 //定义变量 LogInfo logSys = new LogInfo(); //设置日志类型 需要指定为系统日志 logSys.Type = LogInfo.LogType.SYSTEM; //指定系统日志类型 出错信息 logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR; //指定登陆用户信息 logSys.UserInfo = userInfo; //设定模块ID logSys.ModuleID = ConstUtil.MODULE_ID_CUST_COMPLAIN_LIST; //描述 logSys.Description = ex.ToString(); //输出日志 LogUtil.WriteLog(logSys); #endregion } if (isSucc)//操作成功 { logModel.Remark += "成功"; } else//操作失败 { logModel.Remark += "失败"; } //记录日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
public static DataTable GetComplainInfoByComplainPerson(string ComplainPerson, string CustName, CustComplainModel CustComplainM, string ComplainBegin, string ComplainEnd, string CustLinkMan, string DestClerk, int pageIndex, int pageCount, string ord, ref int totalCount) { return(ComplainDBHelper.GetComplainInfoByComplainPerson(ComplainPerson, CustName, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, pageIndex, pageCount, ord, ref totalCount)); }