public ResponseResult <GridResponse <PdtPlnItem> > SearchCriteria(string date, Enum line, GridSettings gridSettings) { string kndLine; var result = _unitOfWork.PdtPlnRepository.GetAll(); if (!string.IsNullOrEmpty(date)) { date = "01/" + date; var mydate = ConvertHelper.ConvertToDateTimeFull(date); var endDate = mydate.AddMonths(1); result = result.Where(i => i.F39_KndEptBgnDate >= mydate && i.F39_KndEptBgnDate < endDate); } if (line != null) { kndLine = Constants.KndLine.Megabit.Equals(line) ? "0" : "1"; result = result.Where(i => i.F39_KneadingLine.Equals(kndLine)); } var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); //result = result.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize); var lstResult = Mapper.Map <IEnumerable <TX39_PdtPln>, IEnumerable <PdtPlnItem> >(result.ToList()); var resultModel = new GridResponse <PdtPlnItem>(lstResult, itemCount); return(new ResponseResult <GridResponse <PdtPlnItem> >(resultModel, true)); }
public ResponseResult <GridResponse <CommonSearchItem> > GetProductCode(string code, GridSettings gridSettings) { var result = _unitOfWork.ProductRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { result = result.Where( i => i.F09_ProductCode.ToUpper().Contains(code.ToUpper()) || i.F09_ProductDesp.ToUpper().Contains(code.ToUpper())); } // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { F09_ProductCode = s.F09_ProductCode, F09_ProductDesp = s.F09_ProductDesp }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
/// <summary> /// Search kneading commands and gridize 'em /// </summary> /// <param name="gridSettings"></param> /// <returns></returns> public async Task <ResponseResult <GridResponse <object> > > SearchTabletisingKneadingCommands( GridSettings gridSettings) { var pageIndex = gridSettings.PageIndex - 1; if (pageIndex < 0) { pageIndex = 0; } var kneadingCommandResults = await RetrieveTabletisingKneadingCommand(pageIndex, gridSettings.PageSize); foreach (var kc in kneadingCommandResults.KneadingCommands) { if (kc.Status.Equals("4")) { kc.Status = "Yet"; } if (kc.Status.Equals("7")) { kc.Status = "Command"; } } // Build a grid and respond to client. var resultModel = new GridResponse <object>(kneadingCommandResults.KneadingCommands, kneadingCommandResults.Total); return(new ResponseResult <GridResponse <object> >(resultModel, true)); }
public virtual ActionResult GetChildren(GridRequest requst, int market, string marketplaceId, int listingsMode, string parentAsin) { try { LogI("GetChildren, parentAsin=" + parentAsin + ", market=" + market + ", marketplaceId=" + marketplaceId + ", listingsMode=" + listingsMode); var items = ItemViewModel.GetAll(Db, (MarketType)market, marketplaceId, parentAsin, (ListingsModeType)listingsMode) .ToList() .OrderBy(i => i.StyleString) .ThenBy(i => i.SizeIndex) .ThenBy(i => i.Size) .ThenBy(i => i.Color) .ThenBy(i => i.SKU) .ToList(); var data = new GridResponse <ItemViewModel>(items, items.Count); return(JsonGet(data)); } catch (Exception ex) { LogE("GetChildren", ex); throw; } }
public JsonResult GetData() { try { var path = Path.Combine(Server.MapPath("~/Output/"), "Generated.csv"); var response = new List <Model1Response>(); if (System.IO.File.Exists(path)) { using (TextReader fileReader = System.IO.File.OpenText(path)) { var csv = new CsvReader(fileReader); csv.Configuration.HasHeaderRecord = true; response = csv.GetRecords <Model1Response>().ToList(); } } var gridRes = new GridResponse <Model1Response>(); gridRes.current = 1; gridRes.rowCount = new int[1]; gridRes.rowCount[0] = -1; gridRes.total = response.Count; gridRes.rows = response; return(Json(gridRes)); } catch (Exception ex) { log.Error(ex); return(Json(ex)); } }
public ResponseResult <GridResponse <CommonSearchItem> > GetShelfNo(string code, GridSettings gridSettings) { gridSettings.SortField = "F37_ShelfStatus"; var result = _unitOfWork.PreProductShelfStatusRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { result = result.Where( i => i.F37_ShelfStatus.Contains(code) || i.F37_ShelfBay.Contains(code) || i.F37_ShelfLevel.Contains(code)); } //result.Where( // i => i.F37_ShelfStatus.Contains(string.Format("{0}", Constants.F37_ShelfStatus.EmptyShelf)) // && i.F37_LowTmpCls.Equals(string.Format("{0}", Constants.F37_lowtmpcls.One))); // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { ShelfNo = s.F37_ShelfRow + '-' + s.F37_ShelfBay + '-' + s.F37_ShelfLevel }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
public ResponseResult <GridResponse <KneadingCommandItem> > SearchCriteria(string productCode, GridSettings gridSettings) { var result = _unitOfWork.KneadingCommandRepository.GetAll(); var productsheft = _unitOfWork.ProductShelfRepository.GetAll(); var productsheftstock = _unitOfWork.ProductShelfStockRepository.GetAll(); if (!string.IsNullOrEmpty(productCode)) { result = result.Where(x => x.F42_KndCmdNo.Trim() == productCode.Trim()).OrderBy(x => x.F42_LotSeqNo); var result1 = result.Select(x => new KneadingCommandItem() { F42_PrePdtLotNo = x.F42_PrePdtLotNo, F42_KndBgnDate = x.F42_KndBgnDate, F42_TrwEndDate = x.F42_TrwEndDate, F42_KndEndDate = x.F42_KndEndDate, F42_StgCtnAmt = x.F42_StgCtnAmt, F42_Status = x.F42_Status.Trim().Equals("0") ? "Not Kneaded" : x.F42_Status.Trim().Equals("1") ? "Kneading" : x.F42_Status.Trim().Equals("2") ? "Completed" : x.F42_Status.Trim().Equals("3") ? "Forced Completed" : x.F42_Status.Trim().Equals("4") ? "Stored" : x.F42_Status.Trim().Equals("5") ? "Tabletised" : x.F42_Status.Trim().Equals("6") ? "Knead Command" : x.F42_Status.Trim().Equals("7") ? "Tablet Command" : x.F42_Status.Trim().Equals("8") ? "Forced Retrieving" : "Forced Retrieved", F42_LotSeqNo = x.F42_LotSeqNo, F42_ThrowAmount = x.F42_ThrowAmount }); var itemCount = result1.Count(); if (gridSettings != null) { OrderByAndPaging(ref result1, gridSettings); } //total = result.Sum(i => i.F43_LayinginAmount); var resultModel = new GridResponse <KneadingCommandItem>(result1, itemCount); return(new ResponseResult <GridResponse <KneadingCommandItem> >(resultModel, true)); } else { var result1 = result.Select(x => new KneadingCommandItem() { F42_PrePdtLotNo = x.F42_PrePdtLotNo, F42_KndBgnDate = x.F42_KndBgnDate, F42_TrwEndDate = x.F42_TrwEndDate, F42_KndEndDate = x.F42_KndEndDate, F42_StgCtnAmt = x.F42_StgCtnAmt, F42_Status = x.F42_Status.Trim().Equals("0") ? "Not Kneaded" : x.F42_Status.Trim().Equals("1") ? "Kneading" : x.F42_Status.Trim().Equals("2") ? "Completed" : x.F42_Status.Trim().Equals("3") ? "Forced Completed" : x.F42_Status.Trim().Equals("4") ? "Stored" : x.F42_Status.Trim().Equals("5") ? "Tabletised" : x.F42_Status.Trim().Equals("6") ? "Knead Command" : x.F42_Status.Trim().Equals("7") ? "Tablet Command" : x.F42_Status.Trim().Equals("8") ? "Forced Retrieving" : "Forced Retrieved", F42_LotSeqNo = x.F42_LotSeqNo, F42_ThrowAmount = x.F42_ThrowAmount }); var itemCount = result.Count(); if (gridSettings != null) { OrderByAndPaging(ref result1, gridSettings); } //total = result.Sum(i => i.F43_LayinginAmount); var resultModel = new GridResponse <KneadingCommandItem>(result1, itemCount); return(new ResponseResult <GridResponse <KneadingCommandItem> >(resultModel, true)); } //var itemCount = lstResult.Count(); //var pdtPlnItems = lstResult.AsQueryable(); //OrderByAndPaging(ref pdtPlnItems, gridSettings); //var resultModel = new GridResponse<PdtPlnItem>(pdtPlnItems, itemCount); //return new ResponseResult<GridResponse<PdtPlnItem>>(resultModel, true); }
public ResponseResult <GridResponse <object> > Search(GridSettings gridSettings) { var lstMaterial = _unitOfWork.MaterialRepository.GetAll(); var lstMaterialShelfStock = _unitOfWork.MaterialShelfStockRepository.GetAll(); var lstMterialSheldStatus = _unitOfWork.MaterialShelfStatusRepository.GetAll(); var result = lstMaterialShelfStock.Join(lstMaterial, tx33MtrShfStk => tx33MtrShfStk.F33_MaterialCode, material => material.F01_MaterialCode, (tx33MtrShfStk, material) => new { tx33MtrShfStk, material }) .Join(lstMterialSheldStatus, @t => @t.tx33MtrShfStk.F33_PalletNo, tx31MtrShfStse => tx31MtrShfStse.F31_PalletNo, (@t, tx31MtrShfStse) => new { @t, tx31MtrShfStse }) .OrderBy(@t => @[email protected]_MaterialCode) .OrderBy(@t => @[email protected]_MaterialLotNo) .GroupBy(@t => new { @t.t.material.F01_MaterialCode, @[email protected]_MaterialDsp }) .Select( i => new { i.Key.F01_MaterialCode, i.Key.F01_MaterialDsp, F31_Amount = i.Sum(t => t.tx31MtrShfStse.F31_Amount), unit = "Kg" }); var itemCount = result.Count(); if (gridSettings != null) { OrderByAndPaging(ref result, gridSettings); } var resultModel = new GridResponse <object>(result, itemCount); return(new ResponseResult <GridResponse <object> >(resultModel, true)); }
public ResponseResult <GridResponse <PreProductPlanItem> > SearchCriteria(string date, GridSettings gridSettings) { var result = _unitOfWork.PreProductPlanRepository.GetAll(); if (!string.IsNullOrEmpty(date)) { date = "01/" + date; DateTime myDate = ConvertHelper.ConvertToDateTimeFull(date); result = result.Where(i => i.F94_YearMonth.Equals(myDate)); } var itemCount = result.Count(); if (gridSettings != null) { OrderByAndPaging(ref result, gridSettings); } var lstPreproduct = _unitOfWork.PreProductRepository.GetAll(); var preproductPlan = result.Select( i => new PreProductPlanItem() { F94_PrepdtCode = i.F94_PrepdtCode, F94_YearMonth = i.F94_YearMonth, F94_amount = i.F94_amount, PreProductName = lstPreproduct.FirstOrDefault(o => o.F03_PreProductCode == i.F94_PrepdtCode).F03_PreProductName }); var resultModel = new GridResponse <PreProductPlanItem>(preproductPlan, itemCount); return(new ResponseResult <GridResponse <PreProductPlanItem> >(resultModel, true)); }
public ResponseResult <GridResponse <CommonSearchItem> > GetProductPalletNo(string code, GridSettings gridSettings) { var stockFlag = Constants.F40_StockFlag.TX40_StkFlg_NotStk; var result = _unitOfWork.ProductShelfStockRepository.GetMany(i => i.F40_StockFlag.Equals(stockFlag)); if (!string.IsNullOrEmpty(code)) { result = result.Where( i => i.F40_PalletNo.Trim().Equals(code)); } // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { F40_PalletNo = s.F40_PalletNo }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
/// <summary> /// Find a list of Reception by using pNo and partial delivery information with pagination. /// </summary> /// <param name="gridSettings"></param> /// <param name="pNo"></param> /// <param name="partialDelivery"></param> /// <returns></returns> public ResponseResult <GridResponse <object> > SearchRawMaterial(GridSettings gridSettings, string pNo, string partialDelivery) { // Find the list of receptions. var receptions = _unitOfWork.ReceptionRepository.GetAll(); // Filter reception by using specific conditions. receptions = FindRawMaterials(receptions, pNo, partialDelivery); // Find all materials in database. var materials = _unitOfWork.MaterialRepository.GetAll(); // Join material and select reception to get the list of materials which need delivering. var deliveredMaterials = from reception in receptions from material in materials where reception.F30_MaterialCode.Equals(material.F01_MaterialCode) select new { reception.F30_ExpectDate, reception.F30_PrcOrdNo, reception.F30_PrtDvrNo, reception.F30_MaterialCode, material.F01_MaterialDsp, reception.F30_ExpectAmount, reception.F30_StoragedAmount }; // Do ordering and pagination. OrderByAndPaging(ref deliveredMaterials, gridSettings); // Build a grid and respond to client. var resultModel = new GridResponse <object>(deliveredMaterials, receptions.Count()); return(new ResponseResult <GridResponse <object> >(resultModel, true)); }
public ResponseResult <GridResponse <CommonSearchItem> > GetMaterialCode(string code, GridSettings gridSettings) { var result = _unitOfWork.MaterialRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { result = result.Where( i => i.F01_MaterialCode.ToUpper().Contains(code.ToUpper()) || i.F01_MaterialDsp.ToUpper().Contains(code.ToUpper())); } // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { F01_MaterialCode = s.F01_MaterialCode, F01_MaterialDsp = s.F01_MaterialDsp, F01_Unit = s.F01_Unit, F01_RtrPosCls = s.F01_RtrPosCls, F01_EntrustedClass = s.F01_EntrustedClass, F01_PackingUnit = s.F01_PackingUnit, F01_LiquidClass = EnumsHelper.GetDescription <Constants.Liquid>(ConvertHelper.ToInteger(s.F01_LiquidClass)) }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
public void Load(GridResponse res) { PageSize = res.Request.Rows.Value; PageNumber = res.Request.Page.Value; Total = res.Total; PageCount = res.PageCount; }
public ResponseResult <GridResponse <CommonSearchItem> > GetProductLotNoWithProductCode(string code, GridSettings gridSettings, string productCode = null) { var result = _unitOfWork.ProductShelfStockRepository.GetAll().Where(i => i.F40_StockFlag.Trim() == "3"); if (!string.IsNullOrEmpty(productCode)) { result = result.Where(i => i.F40_ProductCode.Trim().Equals(productCode.Trim())); } if (!string.IsNullOrEmpty(code)) { result = result.Where(i => i.F40_ProductLotNo.ToUpper().Contains(code.ToUpper())); } // Sort and paging OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(i => i.F40_ProductLotNo).Distinct().Select(s => new CommonSearchItem { F40_ProductLotNo = s }); var itemCount = resultLst.Count(); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
public ResponseResult <GridResponse <CommonSearchItem> > GetShippingNo(string code, GridSettings gridSettings) { var result = _unitOfWork.ShippingPlanRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { result = result.Where(i => i.F44_ShipCommandNo.ToUpper().Contains(code.ToUpper())); } // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { ShippingNo = s.F44_ShipCommandNo, ProductCode = s.F44_ProductCode, EndUserName = _unitOfWork.EndUserRepository.Get(e => e.F10_EndUserCode.Equals(s.F44_EndUserCode)).F10_EndUserName }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
public ResponseResult <GridResponse <CommonSearchItem> > GetEndUserCode(string code, GridSettings gridSettings) { var result = _unitOfWork.EndUserRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { result = result.Where( i => i.F10_EndUserCode.ToUpper().Contains(code.ToUpper()) || i.F10_EndUserName.ToUpper().Contains(code.ToUpper())); } // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { F10_EndUserCode = s.F10_EndUserCode, F10_EndUserName = s.F10_EndUserName }); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
//---------------------------------------------------------------------------------------------------- private static void Helper1__PopulateAdditionalTableName(GridResponse rtn) { rtn.TableName_FullSQLName = String.Format("[{0}].[{1}]", rtn.Schema, rtn.TableName); if (rtn.Schema.Contains(" ") && rtn.TableName.Contains(" ")) { rtn.TableName_FullNameLabel = String.Format("[{0}].[{1}]", rtn.Schema, rtn.TableName); } else if (rtn.Schema.Contains(" ")) { rtn.TableName_FullNameLabel = String.Format("[{0}].{1}", rtn.Schema, rtn.TableName); } else if (rtn.TableName.Contains(" ")) { rtn.TableName_FullNameLabel = String.Format("{0}.[{1}]", rtn.Schema, rtn.TableName); } else { rtn.TableName_FullNameLabel = String.Format("{0}.{1}", rtn.Schema, rtn.TableName); } bool hideSchemaPrefix = false; // to be pulled from settings if (hideSchemaPrefix) { rtn.TableName_FullNameLabel = rtn.TableName; } }
public ResponseResult <GridResponse <PdtPlnItem> > SearchCriteriaSelected(string selectedValue, GridSettings gridSettings) { var result = new List <TX39_PdtPln>(); var lstPdtPln = _unitOfWork.PdtPlnRepository.GetAll(); string[] s = selectedValue.TrimEnd('#').Split('#'); for (int i = 0; i < s.Length; i++) { var date = ConvertHelper.ConvertToDateTimeFull(s[i].Split(',')[0]); var preProductCode = s[i].Split(',')[1]; result.Add(lstPdtPln.FirstOrDefault(c => c.F39_KndEptBgnDate == date && c.F39_PreProductCode.Trim() == preProductCode.Trim())); } var lstResult = new List <PdtPlnItem>(); foreach (var prtPln in result.ToList()) { var prdPlnItem = new PdtPlnItem(); var preProductItem = _unitOfWork.PreProductRepository.GetMany(i => i.F03_PreProductCode == prtPln.F39_PreProductCode).FirstOrDefault(); var kndCmdItem = _unitOfWork.KneadingCommandRepository.GetMany(i => i.F42_PreProductCode == prtPln.F39_PreProductCode && i.F42_KndEptBgnDate == prtPln.F39_KndEptBgnDate).FirstOrDefault(); prdPlnItem.F39_KndEptBgnDate = prtPln.F39_KndEptBgnDate; prdPlnItem.F39_PreProductCode = prtPln.F39_PreProductCode; prdPlnItem.F39_PrePdtLotAmt = prtPln.F39_PrePdtLotAmt; prdPlnItem.F39_Status = prtPln.F39_Status; prdPlnItem.F39_AddDate = prtPln.F39_AddDate; if (preProductItem != null) { prdPlnItem.Quantity = preProductItem.F03_BatchLot; prdPlnItem.F39_PreProductName = preProductItem.F03_PreProductName; prdPlnItem.YieldDrate = preProductItem.F03_YieldRate; prdPlnItem.MaterialAmount = preProductItem.F03_AllMtrAmtPerBth; } if (kndCmdItem != null) { prdPlnItem.CmdNo = kndCmdItem.F42_KndCmdNo; prdPlnItem.LotNo = kndCmdItem.F42_PrePdtLotNo; prdPlnItem.CommandSequenceNo = kndCmdItem.F42_CommandSeqNo; } lstResult.Add(prdPlnItem); } var itemCount = lstResult.Count(); var queryable = lstResult.AsQueryable(); //OrderByAndPaging(ref queryable, gridSettings); queryable = queryable.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize); var resultModel = new GridResponse <PdtPlnItem>(queryable, itemCount); return(new ResponseResult <GridResponse <PdtPlnItem> >(resultModel, true)); }
public ResponseResult <GridResponse <RetrievalOfPreProductItem> > SearchCriteria(GridSettings gridSettings) { var notTablet = Constants.F41_Status.NotTablet; var containerSet = Constants.F41_Status.ContainerSet; var containerSetWait = Constants.F41_Status.ContainerSetWait; var containerSetError = Constants.F41_Status.ContainerSetError; //find TX41_TbtCmd record with f41_tblcntamt > f41_rtrendcntamt var tabletCommands = _unitOfWork .TabletCommandRepository .GetMany(i => (i.F41_Status.Equals(notTablet) || i.F41_Status.Equals(containerSet) || i.F41_Status.Equals(containerSetWait) || i.F41_Status.Equals(containerSetError)) && (i.F41_TblCntAmt > i.F41_RtrEndCntAmt)); //find TX42_KndCmd record with f42_outsideclass = tx42_outsidecls_prepdt(0) and f42_status =stored(4) var outSiteClass = Constants.F42_OutSideClass.PreProduct.ToString("D"); var f42_status = Constants.F42_Status.TX42_Sts_Tbtcmd; var kneadingCommands = _unitOfWork.KneadingCommandRepository.GetMany(i => i.F42_OutSideClass.Equals(outSiteClass) && i.F42_Status.Equals(f42_status)); //find TM03_PreProduct records var preProducts = _unitOfWork.PreProductRepository.GetAll(); var results = from tabletCommand in tabletCommands from kneadingCommand in kneadingCommands from preProduct in preProducts where tabletCommand.F41_KndCmdNo.Trim().Equals(kneadingCommand.F42_KndCmdNo.Trim()) && tabletCommand.F41_PrePdtLotNo.Trim().Equals(kneadingCommand.F42_PrePdtLotNo.Trim()) && tabletCommand.F41_PreproductCode.Trim().Equals(kneadingCommand.F42_PreProductCode.Trim()) && tabletCommand.F41_PreproductCode.Trim().Equals(preProduct.F03_PreProductCode.Trim()) orderby tabletCommand.F41_KndCmdNo, kneadingCommand.F42_LotSeqNo select new RetrievalOfPreProductItem { F41_KndCmdNo = tabletCommand.F41_KndCmdNo, F41_PreproductCode = tabletCommand.F41_PreproductCode, PreProductName = preProduct.F03_PreProductName, F41_PrePdtLotNo = tabletCommand.F41_PrePdtLotNo, ThrowAmount = kneadingCommand.F42_ThrowAmount, F41_TabletLine = tabletCommand.F41_TabletLine, F41_TblCntAmt = tabletCommand.F41_TblCntAmt, F41_RtrEndCntAmt = tabletCommand.F41_RtrEndCntAmt, LotSeqNo = kneadingCommand.F42_LotSeqNo, Line = tabletCommand.F41_TabletLine.Substring(tabletCommand.F41_TabletLine.Trim().Length - 2, 2), ContQuanty = tabletCommand.F41_TblCntAmt - tabletCommand.F41_RtrEndCntAmt }; var itemCount = results.Count(); // Sort and paging OrderByAndPaging(ref results, gridSettings); var lstResult = Mapper.Map <IEnumerable <TX41_TbtCmd>, IEnumerable <RetrievalOfPreProductItem> >( results); var resultModel = new GridResponse <RetrievalOfPreProductItem>(lstResult, itemCount); return(new ResponseResult <GridResponse <RetrievalOfPreProductItem> >(resultModel, true)); }
public JsonResult GetAuditLogs(GridRequest <AuditLogVM> model) { var records = _auditLogService.GetAuditLogs(); GridResponse tableResult = new GridResponse(model.draw, records.Data, records.Data.Count, records.Data.Count); return(Json(tableResult, JsonRequestBehavior.AllowGet)); }
public ResponseResult <GridResponse <object> > SearchDataWindow2(DateTime inputDate, DateTime dateData, string location, GridSettings gridSettings) { var lstTe80 = _unitOfWork.EnvMespRepository.GetMany(i => DbFunctions.AddDays(i.F80_D_From, -1) >= inputDate && DbFunctions.AddDays(i.F80_D_To, -1) <= dateData); var itemCount = lstTe80.Count(); var resultModel = new GridResponse <object>(lstTe80, itemCount); return(new ResponseResult <GridResponse <object> >(resultModel, true)); }
/// <summary> /// Find list of out of plan of product. /// </summary> /// <param name="productCode"></param> /// <param name="gridSettings"></param> /// <returns></returns> public ResponseResult <GridResponse <OutOfPlanProductItem> > FindOutOfPlanProduct(string productCode, GridSettings gridSettings) { var outPlanProducts = _unitOfWork.OutOfPlanProductRepository.GetAll(); var products = _unitOfWork.ProductRepository.GetAll(); var result = from outPlanProduct in outPlanProducts join product in products on outPlanProduct.F58_ProductCode.Trim() equals product.F09_ProductCode.Trim() where outPlanProduct.F58_StorageAmt.Equals(0) orderby new { outPlanProduct.F58_PrePdtLotNo, outPlanProduct.F58_ProductCode } select new { outPlanProduct.F58_ProductCode, product.F09_ProductDesp, outPlanProduct.F58_PrePdtLotNo, outPlanProduct.F58_ProductLotNo, outPlanProduct.F58_TbtCmdEndPackAmt, //Pack Qty outPlanProduct.F58_TbtCmdEndFrtAmt, //Fraction outPlanProduct.F58_TbtEndDate //Tabletising }; if (!string.IsNullOrEmpty(productCode)) { result = result.Where(x => x.F58_ProductCode.Trim().StartsWith(productCode)); } var lstResult = new List <OutOfPlanProductItem>(); foreach (var item in result) { var storageOfProductItem = new OutOfPlanProductItem(); storageOfProductItem.F58_ProductCode = item.F58_ProductCode; storageOfProductItem.ProductName = item.F09_ProductDesp; storageOfProductItem.F58_PrePdtLotNo = item.F58_PrePdtLotNo; storageOfProductItem.F58_ProductLotNo = item.F58_ProductLotNo; storageOfProductItem.F58_TbtCmdEndPackAmt = item.F58_TbtCmdEndPackAmt; storageOfProductItem.F58_TbtCmdEndFrtAmt = item.F58_TbtCmdEndFrtAmt; storageOfProductItem.F58_TbtEndDate = item.F58_TbtEndDate; lstResult.Add(storageOfProductItem); } var itemCount = lstResult.Count(); var lsResult = lstResult.AsQueryable(); if (gridSettings != null) { OrderByAndPaging(ref lsResult, gridSettings); } var resultModel = new GridResponse <OutOfPlanProductItem>(lsResult, itemCount); return(new ResponseResult <GridResponse <OutOfPlanProductItem> >(resultModel, true)); }
/// <summary> /// Load kneading commands from database. /// </summary> /// <param name="gridSettings"></param> /// <param name="kneadingCommandline"></param> /// <returns></returns> public async Task <ResponseResult <GridResponse <object> > > LoadKneadingCommands(GridSettings gridSettings, Constants.KndLine kneadingCommandline) { var kneadingLineMegabit = Constants.KndLine.Megabit.ToString("D"); // Find all kneading commands (TX42_KndCmd) var kneadingCommands = _unitOfWork.PdtPlnRepository.GetAll(); // Find all Preproducts (TM03_PreProduct) var preProducts = _unitOfWork.PreProductRepository.GetAll(); if (kneadingCommandline == Constants.KndLine.Conventional) { kneadingCommands = kneadingCommands.Where(x => x.F39_KneadingLine.Trim().Equals("1")); } else { kneadingCommands = kneadingCommands.Where(x => x.F39_KneadingLine.Trim().Equals("0")); } kneadingCommands = kneadingCommands.Where(x => x.F39_Status.Trim() != "0"); var loadKneadingCommandsResult = from kneadingCommand in kneadingCommands join preproduct in preProducts on kneadingCommand.F39_PreProductCode.Trim() equals preproduct.F03_PreProductCode.Trim() select new PdtPlnItem1 { F39_KndCmdNo = kneadingCommand.F39_KndCmdNo, F39_PreProductCode = kneadingCommand.F39_PreProductCode, F03_PreProductName = preproduct.F03_PreProductName, LotNo = kneadingCommand.F39_StartLotNo, MaterialAmount = kneadingCommand.F39_PrePdtLotAmt, F39_Status = kneadingCommand.F39_Status == "0" ? "Yet" : kneadingCommand.F39_Status == "1"? "Command": kneadingCommand.F39_Status == "2" ? "Produce" : kneadingCommand.F39_Status == "3" ? "End" : kneadingCommand.F39_Status == "4" ? "F End" : kneadingCommand.F39_Status == "5" ? "Stopped" : kneadingCommand.F39_Status == "6" ? "Stopping" : "" }; //Ascending order by: [F39_commandseqno], then [F39_lotseqno] loadKneadingCommandsResult = loadKneadingCommandsResult.OrderBy(x => new { x.F39_KndCmdNo }); // Count the total record which matches with the conditions. var totalRecords = await loadKneadingCommandsResult.CountAsync(); var realPageIndex = gridSettings.PageIndex - 1; // Do pagination. loadKneadingCommandsResult = loadKneadingCommandsResult.Skip(realPageIndex * gridSettings.PageSize) .Take(gridSettings.PageSize); // Build a grid and respond to client. var resultModel = new GridResponse <object>(loadKneadingCommandsResult, totalRecords); return(new ResponseResult <GridResponse <object> >(resultModel, true)); }
public async Task <ResponseResult <GridResponse <ProductListingBusinessModel> > > Search(SearchCriteriaModel model, GridSettings gridSettings) { var items = from p in _iTemoUnitOfWork.ProductRepository.GetAll() join c in _iTemoUnitOfWork.CategoryRepository.GetAllNonDelete() on p.CategoryId equals c.Id into data from item in data.DefaultIfEmpty() select new ProductListingBusinessModel { Id = p.Id, Name = p.Name, Code = p.Code, Description = p.Description, Qty = p.Qty, Status = p.Status, Category = item.Name, IsDeleted = p.IsDeleted, CreatedById = p.CreatedById }; switch (model.ViewName) { case Constants.ProductViewType.InActiveProducts: items = items.Where(r => r.IsDeleted); break; case Constants.ProductViewType.MyProducts: items = items.Where(r => r.CreatedById != null); break; case Constants.ProductViewType.AllProducts: items = items.Where(r => !r.IsDeleted); break; default: items = items.Where(r => !r.IsDeleted); break; } if (!string.IsNullOrEmpty(model.Keyword)) { items = items.Where(r => r.Name.Contains(model.Keyword) || r.Description.Contains(model.Keyword) || r.Code.Contains(model.Keyword) || r.Status.Contains(model.Keyword) || r.Category.Contains(model.Keyword)); } var totalItems = await items.CountAsync(); OrderBy(ref items, gridSettings); Paging(ref items, gridSettings); var results = new GridResponse <ProductListingBusinessModel>(await items.ToListAsync(), totalItems); return(new ResponseResult <GridResponse <ProductListingBusinessModel> >(results, true)); }
public virtual ActionResult GetAll(GridRequest request) { LogI("GetAll"); var searchFilter = new StyleSearchFilterViewModel(); var items = StyleLiteCountingViewModel.GetAll(Db, searchFilter).ToList(); var data = new GridResponse <StyleLiteCountingViewModel>(items, items.Count, Time.GetAppNowTime()); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ResponseResult <GridResponse <CommonSearchItem> > GetPONo(string materialCode, string code, GridSettings gridSettings) { var receptions = _unitOfWork.ReceptionRepository.GetAll().Where(i => i.F30_StoragedAmount < i.F30_ExpectAmount); var materials = _unitOfWork.MaterialRepository.GetAll(); if (!string.IsNullOrEmpty(materialCode)) { receptions = receptions.Where( i => i.F30_MaterialCode.Trim().Equals(materialCode.Trim())); } if (!string.IsNullOrEmpty(code)) { receptions = receptions.Where( i => i.F30_PrcOrdNo.ToUpper().Contains(code.ToUpper()) || i.F30_PrtDvrNo.ToUpper().Contains(code.ToUpper())); } var result = from reception in receptions join material in materials on reception.F30_MaterialCode equals material.F01_MaterialCode //where //( // reception.F30_MaterialCode = material.F01_MaterialCode //) select new { material.F01_MaterialCode, material.F01_MaterialDsp, material.F01_PackingUnit, reception.F30_PrcOrdNo, reception.F30_PrtDvrNo }; // Sort and paging var itemCount = result.Count(); OrderByAndPaging(ref result, gridSettings); var resultLst = result.ToList().Select(s => new CommonSearchItem { F30_PrcOrdNo = s.F30_PrcOrdNo, F30_PrtDvrNo = s.F30_PrtDvrNo, F33_MaterialCode = s.F01_MaterialCode, MaterialName = s.F01_MaterialDsp, F01_PackingUnit = s.F01_PackingUnit }); //var lstResult = Mapper.Map<IEnumerable<TM01_Material>, IEnumerable<MaterialItem>>(result.ToList()); var resultModel = new GridResponse <CommonSearchItem>(resultLst, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); //return result; }
public ResponseResult <GridResponse <CommonSearchItem> > GetPalletNoWithStockFlag(string code, GridSettings gridSettings) { var stockFlag = Constants.F33_StockFlag.TX33_StkFlg_NotStk; var materialShelfStocks = _unitOfWork.MaterialShelfStockRepository.GetMany(i => i.F33_StockFlag.Equals(stockFlag)); var materials = _unitOfWork.MaterialRepository.GetAll(); //var productShelfStatuses = _unitOfWork.ProductShelfStatusRepository.GetAll(); if (!string.IsNullOrEmpty(code)) { materialShelfStocks = materialShelfStocks.Where( i => i.F33_PalletNo.Trim().Contains(code.Trim())); } var result = from materialShelfStock in materialShelfStocks from material in materials //from productShelfStatus in productShelfStatuses where ( materialShelfStock.F33_MaterialCode.Equals(material.F01_MaterialCode.Trim()) //&& materialShelfStock.F33_PalletNo.Equals(productShelfStatus.F51_PalletNo) ) select new CommonSearchItem { //ShelfNo = productShelfStatus.F51_ShelfRow + "-" + productShelfStatus.F51_ShelfBay + "-" + productShelfStatus.F51_ShelfLevel, F33_PalletNo = materialShelfStock.F33_PalletNo, F33_MaterialCode = materialShelfStock.F33_MaterialCode, MaterialName = material.F01_MaterialDsp, F01_PackingUnit = material.F01_PackingUnit, F01_Unit = material.F01_Unit }; // Sort and paging var itemCount = result.Count(); //OrderByAndPaging(ref result, gridSettings); // Find real page index. var realPageIndex = gridSettings.PageIndex - 1; if (realPageIndex < 0) { realPageIndex = 0; } // Pagination. result = result .OrderBy(x => x.MaterialName) .Skip(realPageIndex * gridSettings.PageSize) .Take(gridSettings.PageSize); var resultModel = new GridResponse <CommonSearchItem>(result, itemCount); return(new ResponseResult <GridResponse <CommonSearchItem> >(resultModel, true)); }
public ResponseResult <GridResponse <Te84_Env_Lot> > GetTable(string productCode, GridSettings settings) { var result = _unitOfWork.EnvLotRepository.GetMany(i => i.F84_ProductCode.Trim().Equals(productCode.Trim())); var itemCount = result.Count(); result = result.OrderBy(i => i.F84_Id); result = result.Skip((settings.PageIndex - 1) * settings.PageSize).Take(settings.PageSize); var resultModel = new GridResponse <Te84_Env_Lot>(result, itemCount); return(new ResponseResult <GridResponse <Te84_Env_Lot> >(resultModel, true)); }
public JsonResult GetAttributeList(GridRequest <AttributeFilter> model) { int page = model.start; int rowsPerPage = model.length; ServiceResultModel <List <AttributeVM> > serviceResult = _attributeService.GetAllAttributeList(model.FilterRequest); var gridRecords = serviceResult.Data.Skip(page).Take(rowsPerPage).ToList(); GridResponse tableResult = new GridResponse(model.draw, gridRecords, serviceResult.Data.Count, serviceResult.Data.Count); return(Json(tableResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetRoomTypeList(GridRequest <RoomTypeFilter> model) { var page = model.start; var rowsPerPage = model.length; var filteredData = _roomTypeService.GetAllRoomTypes(model.FilterRequest); var gridPageRecord = filteredData.Data.Skip(page).Take(rowsPerPage).ToList(); GridResponse tableResult = new GridResponse(model.draw, gridPageRecord, filteredData.Data.Count, filteredData.Data.Count); return(Json(tableResult, JsonRequestBehavior.AllowGet)); }