/// <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));
}
