/// <summary> /// 添加投诉管理Model /// </summary> /// <param name="model">投诉管理Model</param> /// <returns>返回值 小于0 错误 1:正确</returns> public int AddCrmComplaintModel(Model.CrmStructure.MCrmComplaint model) { DbCommand dc = _db.GetStoredProcCommand(proc_AddComplaint); _db.AddInParameter(dc, "xmlstring", DbType.Xml, GetComplaintXmlString(model)); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(dc, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(sqlExceptionCode); } else { return(1); } }
/// <summary> /// 添加投诉管理Model /// </summary> /// <param name="model">投诉管理Model</param> /// <param name="tourCode">团号</param> /// <returns>返回值 -2:公司编号未赋值 -3:团号未赋值 -5:投诉必填信息不完善 0 错误 1:正确</returns> public int AddCrmComplaintModel(Model.CrmStructure.MCrmComplaint model, string tourCode) { if (string.IsNullOrEmpty(tourCode)) { return(-5); } if (string.IsNullOrEmpty(model.ComplaintsName)) { return(-5); } if (string.IsNullOrEmpty(tourCode)) { return(-3); } if (string.IsNullOrEmpty(model.CompanyId)) { return(-2); } model.IssueTime = DateTime.Now; model.ComplaintsId = Guid.NewGuid().ToString(); int result = complaintDal.AddCrmComplaintModel(model); if (result > 0) { SysStructure.BSysLogHandle.Insert("添加质量管理投诉管理:投诉编号编号为:" + model.ComplaintsId + "团号:" + tourCode); } return(result); }
/// <summary> /// 获得投诉管理Xml语句 /// </summary> /// <param name="model"></param> /// <returns></returns> private string GetComplaintXmlString(Model.CrmStructure.MCrmComplaint model) { return(EyouSoft.Toolkit.Function.ReflectionHelp.GetModelXmlString(model)); }