private void btnImportJmsGenzong_Click(object sender, EventArgs e)
{
#region 导入加盟商跟踪数据
db.Database.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); };
try
{
int total = 0;
foreach (DataRow dr in excelTable.Rows)
{
string jmsPhone = dr["加盟商联系方式"].ToString();
JiaMengShangInfo jms = db.JiaMengShangInfo.FirstOrDefault(x => x.JmsPhone == jmsPhone);
JMSGengZong jmsgz = new JMSGengZong();
JMSGengZong lastjmsgz = new JMSGengZong();
if (jms != null)
{
JMSLXR jmslxr = db.JMSLXR.FirstOrDefault(x => x.JmsID == jms.id);
if (jmslxr != null)
{
DateTime shijian = Convert.ToDateTime(dr["第一次电话日期"]);
string jilu = dr["第一次电话记录"] + "";
jmsgz.JmsID = jms.id;
jmsgz.JmsName = jms.JmsName;
jmsgz.LxrID = jmslxr.id;
jmsgz.LxrName = jmslxr.JmsName;
jmsgz.GengzongDateTime = shijian;
jmsgz.GenzongInfo = jilu;
jmsgz.optDateTime = shijian;
jmsgz.GenzongStateID = 1;
jmsgz.optName = dr["跟单人"] + "";
jmsgz.FromType = "software_" + jmsgz.optName;
db.JMSGengZong.Add(jmsgz);
total += db.SaveChanges();
if (dr["最近一次回访电话日期"] != null)
{
if (dr["最近一次回访电话日期"].ToString().Length >= 8)
{
DateTime shijian2 = Convert.ToDateTime(dr["最近一次回访电话日期"]);
string jilu2 = dr["回访电话记录"] + "";
if (string.IsNullOrWhiteSpace(jilu2))
{
jilu2 = "未填跟踪记录";
}
lastjmsgz.JmsID = jms.id;
lastjmsgz.JmsName = jms.JmsName;
lastjmsgz.LxrID = jmslxr.id;
lastjmsgz.LxrName = jmslxr.JmsName;
lastjmsgz.GengzongDateTime = shijian2;
lastjmsgz.GenzongInfo = jilu2;
lastjmsgz.optDateTime = shijian2;
lastjmsgz.GenzongStateID = 1;
lastjmsgz.optName = dr["跟单人"] + "";
lastjmsgz.FromType = "software_" + lastjmsgz.optName;
db.JMSGengZong.Add(lastjmsgz);
total += db.SaveChanges();
}
}
}
}
}
label1.Text = string.Format("总共导入{0},条数据", total);
}
catch (DbEntityValidationException ed)
{
throw ed;
}
catch (DbUpdateException ex)
{
throw ex;
}
#endregion
}
//new SelectListItem { Text = "重点关注", Value = "1" } , new SelectListItem { Text = "持续跟踪", Value = "2" } ,
// new SelectListItem { Text = "无效客户", Value = "3" }
private void btnImportJms_Click(object sender, EventArgs e)
{
#region 导入加盟商数据
db.Database.Log = (log) => { System.Diagnostics.Debug.WriteLine(log); };
try
{
int total = 0;
foreach (DataRow dr in excelTable.Rows)
{
JiaMengShangInfo jms = new JiaMengShangInfo();
JMSLXR lxr = new JMSLXR();
if (string.IsNullOrEmpty(dr["序号"] + ""))
{
continue;
}
jms.JmsName = dr["加盟商姓名"] + "";
jms.JmsStateID = GetStateId(dr["客户状态"] + "");
jms.JmsPhone = dr["加盟商联系方式"] + "";
if (db.JiaMengShangInfo.Count(j => j.JmsPhone == jms.JmsPhone) > 0)
{
Logger.Info("加盟商有相同电话", ":" + jms.JmsName + " :" + jms.JmsPhone);
continue;
}
jms.JmsQuDaoLaiYuan = dr[6] + ""; //dr["渠道来源"] + "";
jms.SaleName = dr["跟单人"] + "";
jms.FromType = "software_" + jms.SaleName;
jms.SaleId = optid;
jms.JmsProvince = dr["省"] + "";
jms.JmsCity = dr["市"] + "";
jms.JmsArea = dr["区/县"] + "";
jms.JmsConShiHangYe = dr["从事行业"] + "";
jms.JmsGuDongGouCheng = dr["股东构成"] + "";
if (string.IsNullOrEmpty(jms.JmsGuDongGouCheng))
{
jms.JmsGuDongGouCheng = "未知";
}
jms.JmsYiXiang = dr["加盟意向"] + "";
if (string.IsNullOrEmpty(jms.JmsYiXiang))
{
jms.JmsYiXiang = "未知";
}
jms.JmsHasWuYe = (dr["目前是否有合适的物业"] + "") == "是" ? "1" : "2";
;
jms.JmsWuYeClass = GetWuyeClass(dr["物业类型"] + "");
jms.JmsWuYeQuYu = dr["物业在城市哪个区域"] + "";
jms.JmsZiJinYuSuan = (dr["预计投入资金"] + "").Replace("~", "-");
if (string.IsNullOrEmpty(jms.JmsZiJinYuSuan))
{
jms.JmsZiJinYuSuan = "未知";
}
jms.JmsHeZuoModel = dr["加盟/合作模式"] + "";
jms.JmsXiaoFeiLi = dr["加盟地消费能力"] + "";
if (string.IsNullOrEmpty(jms.JmsXiaoFeiLi))
{
jms.JmsXiaoFeiLi = "未知";
}
jms.JmsYZHSShuLiang = dr["加盟地现有月子会所数量"] + "";
if (string.IsNullOrEmpty(jms.JmsYZHSShuLiang))
{
jms.JmsYZHSShuLiang = "未知";
}
jms.JmsYZHSJunJia = dr["加盟地月子会所平均价格"] + "";
if (string.IsNullOrEmpty(jms.JmsYZHSJunJia))
{
jms.JmsYZHSJunJia = "未知";
}
jms.JmsYongYouZiYuan = dr["加盟商拥有哪些资源"] + "";
if (string.IsNullOrEmpty(jms.JmsYongYouZiYuan))
{
jms.JmsYongYouZiYuan = "没有任何资源";
}
jms.JmsVisitedXiXi = GetXixiVisit(dr["是否参观过喜喜？"] + "");
jms.optName = jms.SaleName;
jms.optDateTime = DateTime.Now;
//jms.JmsYZHSJunJia
db.JiaMengShangInfo.Add(jms);
db.SaveChanges();
lxr.LxrSex = dr["加盟商性别"] + "";
lxr.JmsName = jms.JmsName;
lxr.JmsID = jms.id;
lxr.LxrPhone = jms.JmsPhone;
lxr.optDateTime = DateTime.Now;
lxr.LxrSex = dr["加盟商性别"] + "";
lxr.LxrName = "默认联系人" + jms.JmsName;
lxr.LxrPwd = jms.JmsPhone;
lxr.LxrStateID = 1;
lxr.FromType = "software_" + jms.SaleName;
lxr.optName = jms.SaleName;
lxr.optId = optid;
db.JMSLXR.Add(lxr);
db.SaveChanges();
total++;
}
//todo
db.SaveChanges();
label1.Text = string.Format("总共导入{0},条数据", total);
}
catch (DbEntityValidationException ed)
{
throw ed;
}
catch (DbUpdateException ex)
{
throw ex;
}
#endregion
}
