//查找我的药品 public async Task <IActionResult> GetMyStockDrugInfos(string searchText, List <int> unitIds = null, int pageIndex = 1, int pageSize = 20) { DateTime dt = DateTime.Now; base.initialData_Page(ref pageIndex, ref pageSize); var bll = new BllCaller.DrugsBllCaller(); var finds = bll.GetMyStockDrugInfos(searchText, unitIds); var count = finds.Count(); var items = finds.OrderByDescending(m => m.DrugCompleteScore).ThenBy(m => m.DrugId).Skip(pageSize * (pageIndex - 1)).Take(pageSize); var prices = await bll.GetMyLastIncomePriceAsync(items, UserSelf.DrugStoreStationId); List <Exp_vwCHIS_Code_Drug_Main> expItems = new List <Exp_vwCHIS_Code_Drug_Main>(); foreach (var item in items) { var mmBg = prices.FirstOrDefault(m => m.DrugId == item.DrugId && m.InUnitId == item.UnitBigId); var mmSm = prices.FirstOrDefault(m => m.DrugId == item.DrugId && m.InUnitId == item.UnitSmallId); var temp = item.CopyPropTo <Exp_vwCHIS_Code_Drug_Main>(); temp.ExpMyLastIncomeBigPrice = mmBg?.IncomePrice; //最后入库的大价格 temp.ExpMyLastIncomeSmallPrice = mmSm?.IncomePrice; //最后入库的小价格 expItems.Add(temp); } base._setDebugText(dt); ViewBag.term = searchText; return(PartialView("_pvSelectDrugItem", new Ass.Mvc.PageListInfo <Exp_vwCHIS_Code_Drug_Main> { DataList = expItems, PageIndex = pageIndex, PageSize = pageSize, RecordTotal = count })); }
public async Task <IActionResult> ImportIncomeExcel(IFormFile file) { return(await TryCatchFuncAsync(async (dd) => { var finds = _pharSvr.ImportIncomeExcel(file); //配置价格 var bll = new BllCaller.DrugsBllCaller(); var prices = await bll.GetMyLastIncomePriceAsync(finds.Select(m => m.DrugId).ToList(), UserSelf.DrugStoreStationId); foreach (var item in finds) { var mmBg = prices.FirstOrDefault(m => m.DrugId == item.DrugId && m.InUnitId == item.outUnitBigId); var mmSm = prices.FirstOrDefault(m => m.DrugId == item.DrugId && m.InUnitId == item.outUnitSmallId); var temp = item.CopyPropTo <Exp_vwCHIS_Code_Drug_Main>(); item.incomePriceBig = mmBg?.IncomePrice; //最后入库的大价格 item.incomePriceSmall = mmSm?.IncomePrice; //最后入库的小价格 } dd.items = finds; return null; })); }