/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ProjectTask_BusinessScale model)
{
return(Dal.ProjectTask_BusinessScale.Instance.Update(model));
}
/// <summary>
/// 将excel中信息同步到ProjectTask_Cust
/// </summary>
public void SyncInfoFromExcel(Entities.ProjectTaskInfo task)
{
if (task.Source == 1 && BLL.ProjectTask_Cust.Instance.Exists(task.PTID) == false)
{
int i = -1;
if (int.TryParse(task.RelationID, out i) == false)
{
return;
}
Entities.ExcelCustInfo excelInfo = BLL.ExcelCustInfo.Instance.GetExcelCustInfo(i);
if (excelInfo == null)
{
return;
}
//插入基本信息
Entities.ProjectTask_Cust c = new Entities.ProjectTask_Cust();
c.PTID = task.PTID;
c.CustName = excelInfo.CustName;
BitAuto.YanFa.Crm2009.Entities.EnumCustomType?ct = this.GetCustTypeByName(excelInfo.TypeName);
c.TypeID = ct.HasValue ? ((int)ct.Value).ToString() : "";
//Crm2009.Entities.EnumCustomIndustry? ci = this.GetCustIndustryByName(excelInfo.IndustryName);
//c.IndustryID = ci.HasValue ? ((int)ci.Value).ToString() : "";
c.ProvinceID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.ProvinceName);
c.CityID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.CityName);
c.CountyID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.CountyName);
c.BrandIDs = BLL.CarBrandHelper.Instance.GetCarBrandIDsByNames(excelInfo.BrandName);
c.Address = excelInfo.Address;
c.OfficeTel = excelInfo.OfficeTel;
c.Fax = excelInfo.Fax;
c.Zipcode = excelInfo.Zipcode;
c.CreateTime = c.LastUpdateTime = DateTime.Now;
c.CreateUserID = c.LastUpdateUserID = BLL.Util.GetLoginUserID();
c.CarType = excelInfo.CarType;
c.ContactName = excelInfo.ContactName;
if (!string.IsNullOrEmpty(excelInfo.ContactName))
{
c.ContactName = excelInfo.ContactName;
}
if (excelInfo.TradeMarketID > 0)
{
c.TradeMarketID = excelInfo.TradeMarketID.ToString();
}
if (excelInfo.CarType > 0)
{
c.CarType = excelInfo.CarType;
}
if (!string.IsNullOrEmpty(excelInfo.TypeName))
{
foreach (BitAuto.YanFa.Crm2009.Entities.EnumCustomType type in (BitAuto.YanFa.Crm2009.Entities.EnumCustomType[])Enum.GetValues(typeof(BitAuto.YanFa.Crm2009.Entities.EnumCustomType)))
{
if (Utils.EnumHelper.GetEnumTextValue(type) == excelInfo.TypeName)
{
c.TypeID = ((int)type).ToString();
break;
}
}
}
if (excelInfo.MonthSales > 0 || excelInfo.MonthStock > 0 || excelInfo.MonthTrade > 0)
{
Entities.ProjectTask_BusinessScale scaleInfo = new Entities.ProjectTask_BusinessScale();
scaleInfo.CreateTime = DateTime.Now;
scaleInfo.CreateUserID = Util.GetLoginUserID();
scaleInfo.MonthSales = excelInfo.MonthSales;
scaleInfo.MonthStock = excelInfo.MonthStock;
scaleInfo.MonthTrade = excelInfo.MonthTrade;
scaleInfo.Status = 0;
scaleInfo.PTID = task.PTID;
BLL.ProjectTask_BusinessScale.Instance.Insert(scaleInfo);
}
BLL.ProjectTask_Cust.Instance.Insert(c);
}
}
