public List <Product> GetSheetValues(string filepath, int ShopID = 0)
{
FileInfo file = new FileInfo(filepath);
if (file != null)
{
List <Product> list = new List <Product>();
using (ExcelPackage package = new ExcelPackage(file))
{
IPro_SortService SortService = this.CreateService <IPro_SortService>();
IBrandService brandService = this.CreateService <IBrandService>();
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
//获取表格的列数和行数
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
for (int row = 2; row <= rowCount; row++)
{
Product modle = new Product();
modle.Id = worksheet.Cells[row, 1].Value.ToString();
modle.ProSortID = SortService.GetProSortID(worksheet.Cells[row, 2].Value.ToString());
modle.ProductName = worksheet.Cells[row, 3].Value.ToString();
modle.ProductCode = worksheet.Cells[row, 4].Value.ToString();
modle.ProSize = worksheet.Cells[row, 5].Value.ToString();
modle.Price = worksheet.Cells[row, 6].Value != DBNull.Value ? Convert.ToDecimal(worksheet.Cells[row, 6].Value) : 0;
modle.BasePrice = worksheet.Cells[row, 7].Value != DBNull.Value ? Convert.ToDecimal(worksheet.Cells[row, 7].Value) : 0;
modle.BatchPrice = worksheet.Cells[row, 8].Value != DBNull.Value ? Convert.ToDecimal(worksheet.Cells[row, 8].Value) : 0;
modle.SharePercent = worksheet.Cells[row, 9].Value != DBNull.Value ? Convert.ToDecimal(worksheet.Cells[row, 10].Value) : 0;
modle.ImageUrl = worksheet.Cells[row, 10].Value.ToString();
modle.ImageList = worksheet.Cells[row, 11].Value.ToString();
modle.Summary = worksheet.Cells[row, 12].Value.ToString();
modle.Contents = worksheet.Cells[row, 13].Value.ToString();
if (!string.IsNullOrEmpty(worksheet.Cells[row, 14].Value.ToString()))
{
if (worksheet.Cells[row, 14].Value.ToString() != "暂无")
{
modle.BrandID = brandService.GetBrandID(worksheet.Cells[row, 14].Value.ToString());
}
else
{
modle.BrandID = "";
}
}
else
{
modle.BrandID = "";
}
modle.ShopID = ShopID;
modle.CreateDate = DateTime.Now;
modle.CreateID = this.CurrentSession.UserId;
list.Add(modle);
}
return(list);
}
}
return(null);
}
public ActionResult Index(string Pid = "0")
{
//List<SysOrg> orgs = this.CreateService<IOrgService>().GetList();
//this.ViewBag.Orgs = orgs;
int ShopID = 0;
if (this.CurrentSession.IsAdmin)
{
}
else
{
ShopID = this.CurrentSession.ShopID;
}
IPro_SortService SortService = this.CreateService <IPro_SortService>();
List <Pro_Sort> ListDistrict = SortService.GetList("", "", ShopID);
ViewBag.SortList = ListDistrict;
ViewBag.Pid = Pid;
IBrandService brandService = this.CreateService <IBrandService>();
List <Brand> ListBrand = brandService.GetList(0, "");
ViewBag.BrandList = ListBrand;
string FileDomain = Globals.Configuration["AppSettings:FileDomain"].ToString();
ViewBag.FileDomain = FileDomain;
return(View());
}
