protected Dictionary <string, BaseItemInfo> ReadXlsItems(string fileName) { Dictionary <string, BaseItemInfo> items = new Dictionary <string, BaseItemInfo>(); try { DataTable data = CommonFun.ReadXLS(fileName); for (int row = 0; row < data.Rows.Count; row++) { try { BaseItemInfo item = new BaseItemInfo(); item.ID = data.Rows[row]["批准文号"].ToString(); item.Name = (string)data.Rows[row]["通用名称"].ToString(); item.ItemName = data.Columns.Contains("商品名称") ? data.Rows[row]["商品名称"].ToString() : ""; item.Created = (string)data.Rows[row]["生产厂家"].ToString(); item.Format = (string)data.Rows[row]["包装规格"].ToString(); string priceStr = (string)data.Rows[row]["平台售价(最低价格)"].ToString(); item.ShopPrice = string.IsNullOrEmpty(priceStr) ? 9999 : Convert.ToDecimal(priceStr); item.PlatformPrice = item.ShopPrice; item.Type = data.Columns.Contains("剂型") ? (string)data.Rows[row]["剂型"].ToString() : ""; item.Inventory = (string)data.Rows[row]["库存"].ToString(); item.SellType = (string)data.Rows[row]["出售方式(零或整)"].ToString(); string key = item.Name + item.Format + item.Created; if (!items.ContainsKey(key)) { items.Add(key, item); } } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { Console.WriteLine(ex); } return(items); }