/// <summary> /// 修改团队回访Model /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateCrmVisitModel(Model.CrmStructure.MCrmVisit model) { DbCommand dc = _db.GetStoredProcCommand(proc_AddVisit); _db.AddInParameter(dc, "VisitId", DbType.AnsiStringFixedLength, model.VisitId); _db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); _db.AddInParameter(dc, "TourId", DbType.AnsiStringFixedLength, model.TourId); _db.AddInParameter(dc, "Identity", DbType.Byte, (int)model.Identity); _db.AddInParameter(dc, "Name", DbType.String, model.Name); _db.AddInParameter(dc, "Telephone", DbType.AnsiString, model.Telephone); _db.AddInParameter(dc, "ReturnType", DbType.Byte, (int)model.ReturnType); _db.AddInParameter(dc, "Total", DbType.String, model.Total); _db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId); _db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime); _db.AddInParameter(dc, "QualityScore", DbType.Double, model.QualityScore); _db.AddInParameter(dc, "xmlDetialString", DbType.Xml, visitDetailDal.GetVisitDetailXmlString(model.VisitDetailList)); 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> /// <returns>返回值 小于0:错误 1:正确</returns> public int AddCrmVisitModel(Model.CrmStructure.MCrmVisit model) { DbCommand dc = _db.GetStoredProcCommand(proc_AddVisit); _db.AddInParameter(dc, "xmlVisitString", DbType.Xml, GetVisitXmlString(model)); _db.AddInParameter(dc, "xmlDetialString", DbType.Xml, visitDetailDal.GetVisitDetailXmlString(model.VisitDetailList)); 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> /// <returns>返回值 -1:公司编号未赋值 -2:团队编号未赋值 -3:订单编号未赋值 -4:团队回访必填信息不完善 小于0:错误 1:正确</returns> public int AddCrmVisitModel(Model.CrmStructure.MCrmVisit model) { if (string.IsNullOrEmpty(model.CompanyId)) { return(-1); } if (string.IsNullOrEmpty(model.TourId)) { return(-2); } if (model.Identity == null) { return(-4); } if (model.ReturnType == null) { return(-4); } if (string.IsNullOrEmpty(model.Name)) { return(-4); } model.IssueTime = DateTime.Now; model.VisitId = Guid.NewGuid().ToString(); for (int i = 0; i < model.VisitDetailList.Count; i++) { model.VisitDetailList[i].VisitId = model.VisitId; } int result = visitDal.AddCrmVisitModel(model); if (result > 0) { SysStructure.BSysLogHandle.Insert("添加质量管理团队回访数据:团队回访编号:" + model.VisitId + "团队编号:" + model.TourId); } return(result); }
/// <summary> /// 获得团队回访Xml语句 /// </summary> /// <param name="model"></param> /// <returns></returns> private string GetVisitXmlString(Model.CrmStructure.MCrmVisit model) { return(EyouSoft.Toolkit.Function.ReflectionHelp.GetModelXmlString(model)); }