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