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;
}
}
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;
}
}
