public void importCustomer()
{
ExcelHelper eh = new ExcelHelper(this.txtFilePath.Text);
String name = eh.GetSheetNames().ElementAt(0);
DataSet ds = eh.ExcelToDataSet(name);
System.Data.DataTable dt = ds.Tables[0];
Dictionary<string, IList<ShopModel>> dictCityShops = new Dictionary<string, IList<ShopModel>>();
ICriteria icr = NHibernateHelper.CreateCriteria<DictModel>();
icr.Add(Restrictions.Eq("type", DictModel.Type.drive_cs.ToString()));
IList<DictModel> drivercss = icr.List<DictModel>();
icr = NHibernateHelper.CreateCriteria<DictModel>();
icr.Add(Restrictions.Eq("type", DictModel.Type.buy_time.ToString()));
IList<DictModel> buytimes = icr.List<DictModel>();
Random random = new Random();
int i = 0;
foreach (DataRow dr in dt.Rows)
{
tsslState.Text = string.Format("数据导入({0}/{1})", ++i, dt.Rows.Count);
CustomerModel customer = new CustomerModel();
customer.name = dr[0].ToString();
customer.mobile = dr[1].ToString();
customer.city = dr[2].ToString();
String region = dr[3].ToString();
if (!string.IsNullOrEmpty(customer.city))
{
IList<ShopModel> shops = null;
if (dictCityShops.ContainsKey(customer.city))
{
shops = dictCityShops[customer.city];
}
else
{
icr = NHibernateHelper.CreateCriteria<ShopModel>();
icr.Add(Restrictions.Like("city", "%" + customer.city + "%"));
shops = icr.List<ShopModel>();
dictCityShops.Add(customer.city, shops);
}
if (shops.Count > 0)
{
customer.province = shops[0].province;
if (!string.IsNullOrEmpty(region))
{
icr = NHibernateHelper.CreateCriteria<ShopModel>();
icr.Add(Restrictions.Like("city", "%" + customer.city + "%"));
icr.Add(Restrictions.Or(Restrictions.Like("smallRegion", "%" + region + "%"), Restrictions.Like("address", "%" + region + "%")));
IList<ShopModel> shops1 = icr.List<ShopModel>();
if (shops1.Count > 0)
{
customer.shop = shops1[random.Next(0, shops1.Count - 1)].name;
}
else
{
customer.shop = shops[random.Next(0, shops.Count - 1)].name;
}
}
else
{
customer.shop = shops[random.Next(0, shops.Count - 1)].name;
}
}
customer.buytime = buytimes[random.Next(0, buytimes.Count - 1)].value;
customer.drivecs = drivercss[random.Next(0, drivercss.Count - 1)].value;
customer.uploadInd = "N";
}
customer.createPk();
JsResultObject re = Toyz4net.Core.Util.NHibernateHelper.SaveOrUpdate(customer, "");
String msg = re.msg;
}
}
private void button1_Click(object sender, EventArgs e)
{
ExcelHelper eh = new ExcelHelper(this.txtFilePath.Text);
String name = eh.GetSheetNames().ElementAt(0);
DataSet ds = eh.ExcelToDataSet(name);
System.Data.DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
ShopModel shop = new ShopModel();
shop.bigRegion = dr[2].ToString();
shop.smallRegion = dr[2].ToString();
shop.province= dr[3].ToString();
shop.city = dr[4].ToString();
shop.name = dr[5].ToString();
shop.id = dr[6].ToString();
shop.address = dr[7].ToString();
shop.brand = dr[8].ToString();
JsResultObject re = Toyz4net.Core.Util.NHibernateHelper.SaveOrUpdate(shop, "");
String msg = re.msg;
}
}