/// <summary> /// 获取固定表 /// </summary> private void GetFixedItem() { try { DataTable data = CommonFun.ReadXLS("KTUnUpdate.xlsx"); 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.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 = (string)data.Rows[row]["剂型"].ToString(); item.Inventory = (string)data.Rows[row]["库存"].ToString(); item.SellType = (string)data.Rows[row]["出售方式(零或整)"].ToString(); //item.Name = (string)data.Rows[row]["通用名称"].ToString(); string key = item.Name + item.Format + item.Created; if (!unUpdate.ContainsKey(key)) { unUpdate.Add(key, item); } } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { Console.WriteLine(ex); } }