예제 #1
0
        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;
            }
        }
예제 #2
0
        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;
            }
        }