public JobOrderDetail GetJobOrderDetail(int JobOrderLineId) { var temp = (from L in _unitOfWork.Repository <ViewJobOrderBalance>().Instance join Dl in _unitOfWork.Repository <JobOrderLine>().Instance on L.JobOrderLineId equals Dl.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() join Dh in _unitOfWork.Repository <JobOrderHeader>().Instance on L.JobOrderHeaderId equals Dh.JobOrderHeaderId into JobOrderHeaderTable from JobOrderHeaderTab in JobOrderHeaderTable.DefaultIfEmpty() where L.JobOrderLineId == JobOrderLineId select new JobOrderDetail { JobOrderHeaderDocNo = L.JobOrderNo, ProductId = L.ProductId, ProductName = L.Product.ProductName, Dimension1Id = L.Dimension1Id, Dimension1Name = L.Dimension1.Dimension1Name, Dimension2Id = L.Dimension2Id, Dimension2Name = L.Dimension2.Dimension2Name, MachineId = JobOrderHeaderTab.MachineId, MachineName = JobOrderHeaderTab.Machine.ProductName, Qty = L.BalanceQty, BalanceQty = L.BalanceQty, LotNo = JobOrderLineTab.LotNo, UnitId = JobOrderLineTab.UnitId }).FirstOrDefault(); return(temp); }
public object GetProductUidDetail(string ProductUidName, int filter) { var Header = new JobInvoiceReturnHeaderService(db).Find(filter); var temp = (from i in db.JobInvoiceLine join L in db.JobReceiveLine on i.JobReceiveLineId equals L.JobReceiveLineId join H in db.JobReceiveHeader on L.JobReceiveHeaderId equals H.JobReceiveHeaderId into JobReceiveHeaderTable from JobReceiveHeaderTab in JobReceiveHeaderTable.DefaultIfEmpty() join Jol in db.JobOrderLine on L.JobOrderLineId equals Jol.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() join Pu in db.ProductUid on(JobOrderLineTab.ProductUidHeaderId == null ? JobOrderLineTab.ProductUidId : L.ProductUidId) equals Pu.ProductUIDId into ProductUidTable from ProductUidTab in ProductUidTable.DefaultIfEmpty() where ProductUidTab.ProductUidName == ProductUidName && JobReceiveHeaderTab.ProcessId == Header.ProcessId && JobReceiveHeaderTab.SiteId == Header.SiteId && JobReceiveHeaderTab.DivisionId == Header.DivisionId && JobReceiveHeaderTab.JobWorkerId == Header.JobWorkerId orderby JobReceiveHeaderTab.DocDate select new { ProductUidId = ProductUidTab.ProductUIDId, JobInvoiceLineId = i.JobInvoiceLineId, JobInvoiceDocNo = i.JobInvoiceHeader.DocNo, Success = (i.JobInvoiceHeader.JobWorkerId == Header.JobWorkerId ? true : false), ProdUidHeaderId = JobOrderLineTab.ProductUidHeaderId, }).ToList().Last(); return(temp); }
public IEnumerable <JobOrderHeaderListViewModel> GetPendingJobOrdersWithPatternMatch(int JobWorkerId, string term, int Limiter)//Product Id { var DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"]; var SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"]; var tem = (from p in db.ViewJobOrderBalance join D1 in db.Dimension1 on p.Dimension1Id equals D1.Dimension1Id into Dimension1Table from Dimension1Tab in Dimension1Table.DefaultIfEmpty() join D2 in db.Dimension2 on p.Dimension2Id equals D2.Dimension2Id into Dimension2Table from Dimension2Tab in Dimension2Table.DefaultIfEmpty() join D3 in db.Dimension3 on p.Dimension3Id equals D3.Dimension3Id into Dimension3Table from Dimension3Tab in Dimension3Table.DefaultIfEmpty() join D4 in db.Dimension4 on p.Dimension4Id equals D4.Dimension4Id into Dimension4Table from Dimension4Tab in Dimension4Table.DefaultIfEmpty() join t3 in db.Product on p.ProductId equals t3.ProductId join Jol in db.JobOrderLine on p.JobOrderLineId equals Jol.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() where p.BalanceQty > 0 && p.JobWorkerId == JobWorkerId && p.DivisionId == DivisionId && p.SiteId == SiteId && ((string.IsNullOrEmpty(term) ? 1 == 1 : p.JobOrderNo.ToLower().Contains(term.ToLower())) || (string.IsNullOrEmpty(term) ? 1 == 1 : Dimension1Tab.Dimension1Name.ToLower().Contains(term.ToLower())) || (string.IsNullOrEmpty(term) ? 1 == 1 : Dimension2Tab.Dimension2Name.ToLower().Contains(term.ToLower())) || (string.IsNullOrEmpty(term) ? 1 == 1 : Dimension3Tab.Dimension3Name.ToLower().Contains(term.ToLower())) || (string.IsNullOrEmpty(term) ? 1 == 1 : Dimension4Tab.Dimension4Name.ToLower().Contains(term.ToLower())) || (string.IsNullOrEmpty(term) ? 1 == 1 : t3.ProductName.ToLower().Contains(term.ToLower()))) orderby p.JobOrderNo select new JobOrderHeaderListViewModel { DocNo = p.JobOrderNo, JobOrderLineId = p.JobOrderLineId, Dimension1Name = Dimension1Tab.Dimension1Name, Dimension2Name = Dimension2Tab.Dimension2Name, Dimension3Name = Dimension3Tab.Dimension3Name, Dimension4Name = Dimension4Tab.Dimension4Name, ProductName = t3.ProductName, ProductUidId = JobOrderLineTab.ProductUidId, ProductUidName = JobOrderLineTab.ProductUid.ProductUidName, LotNo = JobOrderLineTab.LotNo, BalanceQty = p.BalanceQty, }).Take(Limiter); return(tem); }
public JobReceiveQAAttributeViewModel GetJobReceiveQAAttributeDetailForEdit(int JobReceiveQALineid) { JobReceiveQAAttributeViewModel JobReceiveQALineDetail = (from L in db.JobReceiveQALine join H in db.JobReceiveQAHeader on L.JobReceiveQAHeaderId equals H.JobReceiveQAHeaderId into JobReceiveQAHeaderTable from JobReceiveQAHeaderTab in JobReceiveQAHeaderTable.DefaultIfEmpty() join Jrl in db.JobReceiveLine on L.JobReceiveLineId equals Jrl.JobReceiveLineId into JobReceiveLineTable from JobReceiveLineTab in JobReceiveLineTable.DefaultIfEmpty() join Jol in db.JobOrderLine on JobReceiveLineTab.JobOrderLineId equals Jol.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() join Ld in db.JobReceiveQALineExtended on L.JobReceiveQALineId equals Ld.JobReceiveQALineId into JobReceiveQALineDetailTable from JobReceiveQALineDetailTab in JobReceiveQALineDetailTable.DefaultIfEmpty() where L.JobReceiveQALineId == JobReceiveQALineid select new JobReceiveQAAttributeViewModel { JobReceiveQALineId = L.JobReceiveQALineId, JobReceiveQAHeaderId = L.JobReceiveQAHeaderId, JobReceiveLineId = L.JobReceiveLineId, JobWorkerId = JobReceiveQAHeaderTab.JobWorkerId, ProductUidId = L.ProductUidId, ProductUidName = L.ProductUid.ProductUidName, ProductId = JobOrderLineTab.ProductId, ProductName = JobOrderLineTab.Product.ProductName, QAQty = L.Qty, InspectedQty = L.Qty, Qty = L.Qty, UnitId = JobOrderLineTab.Product.UnitId, DealUnitId = JobReceiveLineTab.DealUnitId, UnitConversionMultiplier = L.UnitConversionMultiplier, DealQty = L.DealQty, Weight = L.Weight, UnitDecimalPlaces = JobOrderLineTab.Product.Unit.DecimalPlaces, DealUnitDecimalPlaces = JobOrderLineTab.DealUnit.DecimalPlaces, PenaltyRate = L.PenaltyRate, PenaltyAmt = L.PenaltyAmt, DivisionId = JobReceiveQAHeaderTab.DivisionId, SiteId = JobReceiveQAHeaderTab.SiteId, ProcessId = JobReceiveQAHeaderTab.ProcessId, DocDate = JobReceiveQAHeaderTab.DocDate, DocTypeId = JobReceiveQAHeaderTab.DocTypeId, DocNo = JobReceiveQAHeaderTab.DocNo, QAById = JobReceiveQAHeaderTab.QAById, Remark = JobReceiveQAHeaderTab.Remark, Length = JobReceiveQALineDetailTab.Length, Width = JobReceiveQALineDetailTab.Width, Height = JobReceiveQALineDetailTab.Height }).FirstOrDefault(); if (JobReceiveQALineDetail != null) { ProductDimensions ProductDimensions = new ProductService(_unitOfWork).GetProductDimensions(JobReceiveQALineDetail.ProductId, JobReceiveQALineDetail.DealUnitId, JobReceiveQALineDetail.DocTypeId); if (ProductDimensions != null) { JobReceiveQALineDetail.DimensionUnitDecimalPlaces = ProductDimensions.DimensionUnitDecimalPlaces; } } return(JobReceiveQALineDetail); }
public JobReceiveQAAttributeViewModel GetJobReceiveLineDetail(int JobReceiveLineid) { JobReceiveQAAttributeViewModel JobReceiveLineDetail = (from L in db.JobReceiveLine join H in db.JobReceiveHeader on L.JobReceiveHeaderId equals H.JobReceiveHeaderId into JobReceiveHeaderTable from JobReceiveHeaderTab in JobReceiveHeaderTable.DefaultIfEmpty() join Jol in db.JobOrderLine on L.JobOrderLineId equals Jol.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() where L.JobReceiveLineId == JobReceiveLineid select new JobReceiveQAAttributeViewModel { JobReceiveLineId = L.JobReceiveLineId, JobWorkerId = JobReceiveHeaderTab.JobWorkerId, ProductUidId = L.ProductUidId, ProductUidName = L.ProductUid.ProductUidName, ProductId = JobOrderLineTab.ProductId, ProductName = JobOrderLineTab.Product.ProductName, QAQty = L.Qty, InspectedQty = L.Qty, Qty = L.Qty, UnitId = JobOrderLineTab.Product.UnitId, DealUnitId = L.DealUnitId, UnitConversionMultiplier = L.UnitConversionMultiplier, DealQty = L.DealQty, Weight = L.Weight, UnitDecimalPlaces = JobOrderLineTab.Product.Unit.DecimalPlaces, DealUnitDecimalPlaces = JobOrderLineTab.DealUnit.DecimalPlaces, DocTypeId = JobReceiveHeaderTab.DocTypeId }).FirstOrDefault(); if (JobReceiveLineDetail != null) { ProductDimensions ProductDimensions = new ProductService(_unitOfWork).GetProductDimensions(JobReceiveLineDetail.ProductId, JobReceiveLineDetail.DealUnitId, JobReceiveLineDetail.DocTypeId); if (ProductDimensions != null) { JobReceiveLineDetail.Length = ProductDimensions.Length; JobReceiveLineDetail.Width = ProductDimensions.Width; JobReceiveLineDetail.Height = ProductDimensions.Height; JobReceiveLineDetail.DimensionUnitDecimalPlaces = ProductDimensions.DimensionUnitDecimalPlaces; } } return(JobReceiveLineDetail); }
public List <QAGroupLineLineViewModel> GetJobReceiveQAAttribute(int JobReceiveLineid) { List <QAGroupLineLineViewModel> JobReceiveQAAttribute = (from L in db.JobReceiveLine join H in db.JobReceiveHeader on L.JobReceiveHeaderId equals H.JobReceiveHeaderId into JobReceiveHeaderTable from JobReceiveHeaderTab in JobReceiveHeaderTable.DefaultIfEmpty() join Jol in db.JobOrderLine on L.JobOrderLineId equals Jol.JobOrderLineId into JobOrderLineTable from JobOrderLineTab in JobOrderLineTable.DefaultIfEmpty() join Pp in db.ProductProcess on new { X1 = JobOrderLineTab.ProductId, X2 = JobReceiveHeaderTab.ProcessId } equals new { X1 = Pp.ProductId, X2 = (Pp.ProcessId ?? 0) } into ProductProcessTable from ProductProcessTab in ProductProcessTable.DefaultIfEmpty() join QAGl in db.QAGroupLine on ProductProcessTab.QAGroupId equals QAGl.QAGroupId into QAGroupLineTable from QAGroupLineTab in QAGroupLineTable.DefaultIfEmpty() where L.JobReceiveLineId == JobReceiveLineid && ((int?)QAGroupLineTab.QAGroupLineId ?? 0) != 0 select new QAGroupLineLineViewModel { QAGroupLineId = QAGroupLineTab.QAGroupLineId, DefaultValue = QAGroupLineTab.DefaultValue, Value = QAGroupLineTab.DefaultValue, Name = QAGroupLineTab.Name, DataType = QAGroupLineTab.DataType, ListItem = QAGroupLineTab.ListItem }).ToList(); return(JobReceiveQAAttribute); }