/// <summary>
/// 修改销售网络信息
/// </summary>
/// <param name="model">实体类销售网络信息</param>
/// <returns>成功:索引值;失败:-1</returns>
public int UpdataExcelCustInfo(Entities.ExcelCustInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CustName", SqlDbType.VarChar, 100),
new SqlParameter("@TypeName", SqlDbType.VarChar, 100),
new SqlParameter("@ProvinceName", SqlDbType.VarChar, 100),
new SqlParameter("@CityName", SqlDbType.VarChar, 100),
new SqlParameter("@CountyName", SqlDbType.VarChar, 100),
new SqlParameter("@Zipcode", SqlDbType.VarChar, 10),
new SqlParameter("@BrandName", SqlDbType.VarChar, 2000),
new SqlParameter("@OfficeTel", SqlDbType.VarChar, 50),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Address", SqlDbType.VarChar, 400)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CustName;
parameters[2].Value = model.TypeName;
parameters[3].Value = model.ProvinceName;
parameters[4].Value = model.CityName;
parameters[5].Value = model.CountyName;
parameters[6].Value = model.Zipcode;
parameters[7].Value = model.BrandName;
parameters[8].Value = model.OfficeTel;
parameters[9].Value = model.Fax;
parameters[10].Value = model.Address;
return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_EXCELCUSTINFO_UPDATE, parameters));
}
private static Entities.ExcelCustInfo LoadSingleExcelCustInfo(DataRow row)
{
Entities.ExcelCustInfo model = new Entities.ExcelCustInfo();
if (row["ID"] != DBNull.Value)
{
model.ID = Convert.ToInt32(row["ID"].ToString());
}
if (row["CustName"] != DBNull.Value)
{
model.CustName = row["CustName"].ToString();
}
if (row["TypeName"] != DBNull.Value)
{
model.TypeName = row["TypeName"].ToString();
}
if (row["ProvinceName"] != DBNull.Value)
{
model.ProvinceName = row["ProvinceName"].ToString();
}
if (row["CityName"] != DBNull.Value)
{
model.CityName = row["CityName"].ToString();
}
if (row["CountyName"] != DBNull.Value)
{
model.CountyName = row["CountyName"].ToString();
}
if (row["Zipcode"] != DBNull.Value)
{
model.Zipcode = row["Zipcode"].ToString();
}
if (row["BrandName"] != DBNull.Value)
{
model.BrandName = row["BrandName"].ToString();
}
if (row["OfficeTel"] != DBNull.Value)
{
model.OfficeTel = row["OfficeTel"].ToString();
}
if (row["Address"] != DBNull.Value)
{
model.Address = row["Address"].ToString();
}
if (row["CarType"] != DBNull.Value)
{
model.CarType = int.Parse(row["CarType"].ToString());
}
if (row["Fax"] != DBNull.Value)
{
model.Fax = row["Fax"].ToString();
}
if (row["MonthStock"] != DBNull.Value)
{
model.MonthStock = int.Parse(row["MonthStock"].ToString());
}
if (row["MonthSales"] != DBNull.Value)
{
model.MonthSales = int.Parse(row["MonthSales"].ToString());
}
if (row["MonthTrade"] != DBNull.Value)
{
model.MonthTrade = int.Parse(row["MonthTrade"].ToString());
}
if (row["ContactName"] != DBNull.Value)
{
model.ContactName = row["ContactName"].ToString();
}
if (row["TradeMarketID"] != DBNull.Value)
{
model.TradeMarketID = int.Parse(row["TradeMarketID"].ToString());
}
return(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);
}
}
