/// <summary> /// 修改客户服务信息的方法 /// </summary> /// <param name="CustServiceM">服务信息</param> /// <returns>bool值</returns> public static bool UpdateService(CustServiceModel CustServiceM) { 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_SERVICE_LIST; //操作单据编号 客户服务单编号 logModel.ObjectID = CustServiceM.ServeNO; //操作对象 操作的表信息 logModel.ObjectName = ConstUtil.TABLE_NAME_SERVICE; //涉及关键元素 涉及其他业务、表关系 logModel.Element = string.Empty; //备注 操作类型 logModel.Remark = ConstUtil.LOG_PROCESS_UPDATE; #endregion try { isSucc = ServiceDBHelper.UpdateService(CustServiceM); } catch (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_SERVICE_LIST; //描述 logSys.Description = ex.ToString(); //输出日志 LogUtil.WriteLog(logSys); #endregion } if (isSucc)//操作成功 { logModel.Remark += "成功"; } else//操作失败 { logModel.Remark += "失败"; } //记录日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
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) : "BeginDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_d")) { order = "desc";//排序:降序 } string ord = " ORDER BY " + orderBy + " " + order; //获取检索条件 string CustID = hiddCustID.Value; //客户ID CustServiceModel CustServiceM = new CustServiceModel(); CustServiceM.ServeType = Convert.ToInt32(ddlServeType.SelectedItem.Value); //服务类型 CustServiceM.Fashion = Convert.ToInt32(ddlFashion.Value); //服务方式 string ServiceDateBegin = txtServiceDateBegin.Value; string ServiceDateEnd = txtServiceDateEnd.Value; //服务结束时间 CustServiceM.Title = txtTitle.Value.Trim(); //客户服务主题 string Executant = txtExecutant.Value.Trim(); //执行人 string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人 CustServiceM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString(); DataTable dt = ServiceBus.ExportServiceInfo(CanUserID, CustID, CustServiceM, ServiceDateBegin, ServiceDateEnd, Executant, CustLinkMan, ord); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "服务单编号", "服务主题", "服务时间", "客户名称", "服务类型", "服务方式", "执行人", "客户联络人" }, new string[] { "ServeNo", "title", "BeginDate", "custnam", "ServeType", "Fashion", "EmployeeName", "LinkManName" }, "客户服务列表"); } catch { ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>"); } }
public static DataTable GetServiceInfoBycondition(string CanUserID, string CustName, CustServiceModel CustServiceM, string ServiceDateBegin, string ServiceDateEnd, string Executant, string CustLinkMan, int pageIndex, int pageCount, string ord, ref int totalCount) { try { return(ServiceDBHelper.GetServiceInfoBycondition(CanUserID, CustName, CustServiceM, ServiceDateBegin, ServiceDateEnd, Executant, CustLinkMan, pageIndex, pageCount, ord, ref totalCount)); } catch { return(null); } }
/// <summary> /// 导出客户服务信息 /// </summary> /// <param name="CustName"></param> /// <param name="CustServiceM"></param> /// <param name="ServiceDateBegin"></param> /// <param name="ServiceDateEnd"></param> /// <param name="Executant"></param> /// <param name="CustLinkMan"></param> /// <param name="ord"></param> /// <returns></returns> public static DataTable ExportServiceInfo(string CanUserID, string CustID, CustServiceModel CustServiceM, string ServiceDateBegin, string ServiceDateEnd, string Executant, string CustLinkMan, string ord) { return(ServiceDBHelper.ExportServiceInfo(CanUserID, CustID, CustServiceM, ServiceDateBegin, ServiceDateEnd, Executant, CustLinkMan, ord)); }
public static DataTable GetCustServiceByCustID(CustServiceModel CustServiceM, int pageIndex, int pageCount, string ord, ref int TotalCount) { return(CustCallDBHelper.GetCustServiceByCustID(CustServiceM, pageIndex, pageCount, ord, ref TotalCount)); }