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