public IQueryable <ComboBoxResult> GetPendingProductsForJobOrderInspectionRequestCancel(string term, int JobOrderInspectionRequestCancelHeaderId)//DocTypeId
{
JobOrderInspectionRequestCancelHeader header = new JobOrderInspectionRequestCancelHeaderService(db).Find(JobOrderInspectionRequestCancelHeaderId);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(header.DocTypeId, header.DivisionId, header.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderInspectionRequestBalance
join jir in db.JobOrderInspectionRequestHeader on p.JobOrderInspectionRequestHeaderId equals jir.JobOrderInspectionRequestHeaderId
join t in db.Product on p.ProductId equals t.ProductId into ProdTable
from ProTab in ProdTable.DefaultIfEmpty()
where p.BalanceQty > 0 &&
p.SiteId == header.SiteId && p.DivisionId == header.DivisionId && p.JobWorkerId == header.JobWorkerId && jir.ProcessId == header.ProcessId
select new
{
ProductId = p.ProductId,
ProductName = ProTab.ProductName,
DocTypeId = jir.DocTypeId,
SiteId = jir.SiteId,
DivisionId = jir.DivisionId,
}
);
if (!string.IsNullOrEmpty(term))
{
Query = Query.Where(m => m.ProductName.ToLower().Contains(term.ToLower()));
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == header.SiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == header.DivisionId);
}
return(from p in Query
group p by p.ProductId into g
orderby g.Max(m => m.ProductName)
select new ComboBoxResult
{
text = g.Max(m => m.ProductName),
id = g.Key.ToString(),
});
}
public IEnumerable <JobOrderInspectionRequestLineViewModel> GetPendingJobRequestsForAC(int HeaderId, 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 InspectionReqCanHeader = db.JobOrderInspectionRequestCancelHeader.Find(HeaderId);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(InspectionReqCanHeader.DocTypeId, InspectionReqCanHeader.DivisionId, InspectionReqCanHeader.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderInspectionRequestBalance
join jir in db.JobOrderInspectionRequestHeader on p.JobOrderInspectionRequestHeaderId equals jir.JobOrderInspectionRequestHeaderId
where p.BalanceQty > 0 && p.JobWorkerId == InspectionReqCanHeader.JobWorkerId && jir.ProcessId == jir.ProcessId
orderby p.JobOrderInspectionRequestNo
select new
{
JobOrderInspectionRequestHeaderDocNo = p.JobOrderInspectionRequestNo,
JobOrderInspectionRequestLineId = p.JobOrderInspectionRequestLineId,
Dimension1Name = p.Dimension1.Dimension1Name,
Dimension2Name = p.Dimension2.Dimension2Name,
Dimension3Name = p.Dimension3.Dimension3Name,
Dimension4Name = p.Dimension4.Dimension4Name,
ProductName = p.Product.ProductName,
BalanceQty = p.BalanceQty,
DocTypeId = jir.DocTypeId,
SiteId = jir.SiteId,
DivisionId = jir.DivisionId,
});
if (!string.IsNullOrEmpty(term))
{
Query = Query.Where(m => m.JobOrderInspectionRequestHeaderDocNo.ToLower().Contains(term.ToLower()) ||
m.Dimension1Name.ToLower().Contains(term.ToLower()) ||
m.Dimension2Name.ToLower().Contains(term.ToLower()) ||
m.Dimension3Name.ToLower().Contains(term.ToLower()) ||
m.Dimension4Name.ToLower().Contains(term.ToLower()) ||
m.ProductName.ToLower().Contains(term.ToLower()));
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == InspectionReqCanHeader.SiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == InspectionReqCanHeader.DivisionId);
}
return((from p in Query
select new JobOrderInspectionRequestLineViewModel
{
JobOrderInspectionRequestHeaderDocNo = p.JobOrderInspectionRequestHeaderDocNo,
JobOrderInspectionRequestLineId = p.JobOrderInspectionRequestLineId,
Dimension1Name = p.Dimension1Name,
Dimension2Name = p.Dimension2Name,
Dimension3Name = p.Dimension3Name,
Dimension4Name = p.Dimension4Name,
ProductName = p.ProductName,
BalanceQty = p.BalanceQty,
}).Take(Limiter));
}
public IEnumerable <JobOrderInspectionRequestCancelLineViewModel> GetJobOrderInspectionRequestLineForMultiSelect(JobOrderInspectionRequestCancelFilterViewModel svm)
{
string[] ProductIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductId))
{
ProductIdArr = svm.ProductId.Split(",".ToCharArray());
}
else
{
ProductIdArr = new string[] { "NA" };
}
string[] SaleOrderIdArr = null;
if (!string.IsNullOrEmpty(svm.JobOrderInspectionRequestId))
{
SaleOrderIdArr = svm.JobOrderInspectionRequestId.Split(",".ToCharArray());
}
else
{
SaleOrderIdArr = new string[] { "NA" };
}
string[] ProductGroupIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductGroupId))
{
ProductGroupIdArr = svm.ProductGroupId.Split(",".ToCharArray());
}
else
{
ProductGroupIdArr = new string[] { "NA" };
}
string[] Dime1IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension1Id))
{
Dime1IdArr = svm.Dimension1Id.Split(",".ToCharArray());
}
else
{
Dime1IdArr = new string[] { "NA" };
}
string[] Dime2IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension2Id))
{
Dime2IdArr = svm.Dimension2Id.Split(",".ToCharArray());
}
else
{
Dime2IdArr = new string[] { "NA" };
}
string[] Dime3IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension3Id))
{
Dime3IdArr = svm.Dimension3Id.Split(",".ToCharArray());
}
else
{
Dime3IdArr = new string[] { "NA" };
}
string[] Dime4IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension4Id))
{
Dime4IdArr = svm.Dimension4Id.Split(",".ToCharArray());
}
else
{
Dime4IdArr = new string[] { "NA" };
}
var InsReqCanHeader = db.JobOrderInspectionRequestCancelHeader.Find(svm.JobOrderInspectionRequestCancelHeaderId);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(InsReqCanHeader.DocTypeId, InsReqCanHeader.DivisionId, InsReqCanHeader.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderInspectionRequestBalance
join t in db.JobOrderInspectionRequestLine on p.JobOrderInspectionRequestLineId equals t.JobOrderInspectionRequestLineId into table
from tab in table.DefaultIfEmpty()
join jir in db.JobOrderInspectionRequestHeader on p.JobOrderInspectionRequestHeaderId equals jir.JobOrderInspectionRequestHeaderId
join Jol in db.JobOrderLine on tab.JobOrderLineId equals Jol.JobOrderLineId
join product in db.Product on p.ProductId equals product.ProductId into table2
from tab2 in table2.DefaultIfEmpty()
where p.BalanceQty > 0 && p.JobWorkerId == svm.JobWorkerId && jir.ProcessId == InsReqCanHeader.ProcessId
orderby p.RequestDate, p.JobOrderInspectionRequestNo, tab.Sr
select new
{
BalanceQty = p.BalanceQty,
Qty = p.BalanceQty,
JobOrderInspectionRequestDocNo = p.JobOrderInspectionRequestNo,
ProductName = tab2.ProductName,
ProductId = p.ProductId,
JobOrderInspectionRequestCancelHeaderId = svm.JobOrderInspectionRequestCancelHeaderId,
JobOrderInspectionRequestLineId = p.JobOrderInspectionRequestLineId,
Dimension1Id = p.Dimension1Id,
Dimension2Id = p.Dimension2Id,
Dimension3Id = p.Dimension3Id,
Dimension4Id = p.Dimension4Id,
Dimension1Name = p.Dimension1.Dimension1Name,
Dimension2Name = p.Dimension2.Dimension2Name,
Dimension3Name = p.Dimension3.Dimension3Name,
Dimension4Name = p.Dimension4.Dimension4Name,
Specification = Jol.Specification,
UnitId = tab2.UnitId,
UnitName = tab2.Unit.UnitName,
unitDecimalPlaces = tab2.Unit.DecimalPlaces,
DealunitDecimalPlaces = Jol.DealUnit.DecimalPlaces,
ProductUidName = (Jol.ProductUidHeaderId == null ? tab.ProductUid.ProductUidName : ""),
ProductUidId = tab.ProductUidId,
JobOrderInspectionRequestHeaderId = p.JobOrderInspectionRequestHeaderId,
ProdOrderLineId = Jol.ProdOrderLineId,
ProductGroupId = tab2.ProductGroupId,
SiteId = p.SiteId,
DivisionId = p.DivisionId,
DocTypeId = jir.DocTypeId,
});
if (!string.IsNullOrEmpty(svm.ProductId))
{
Query = Query.Where(m => ProductIdArr.Contains(m.ProductId.ToString()));
}
if (!string.IsNullOrEmpty(svm.JobOrderInspectionRequestId))
{
Query = Query.Where(m => SaleOrderIdArr.Contains(m.JobOrderInspectionRequestHeaderId.ToString()));
}
if (!string.IsNullOrEmpty(svm.ProductGroupId))
{
Query = Query.Where(m => ProductGroupIdArr.Contains(m.ProductGroupId.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension1Id))
{
Query = Query.Where(m => Dime1IdArr.Contains(m.Dimension1Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension2Id))
{
Query = Query.Where(m => Dime2IdArr.Contains(m.Dimension2Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension3Id))
{
Query = Query.Where(m => Dime3IdArr.Contains(m.Dimension3Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension4Id))
{
Query = Query.Where(m => Dime4IdArr.Contains(m.Dimension4Id.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == InsReqCanHeader.SiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == InsReqCanHeader.DivisionId);
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
return(from p in Query
select new JobOrderInspectionRequestCancelLineViewModel
{
BalanceQty = p.BalanceQty,
Qty = p.BalanceQty,
JobOrderInspectionRequestDocNo = p.JobOrderInspectionRequestDocNo,
ProductName = p.ProductName,
ProductId = p.ProductId,
JobOrderInspectionRequestCancelHeaderId = svm.JobOrderInspectionRequestCancelHeaderId,
JobOrderInspectionRequestLineId = p.JobOrderInspectionRequestLineId,
Dimension1Id = p.Dimension1Id,
Dimension2Id = p.Dimension2Id,
Dimension3Id = p.Dimension3Id,
Dimension4Id = p.Dimension4Id,
Dimension1Name = p.Dimension1Name,
Dimension2Name = p.Dimension2Name,
Dimension3Name = p.Dimension3Name,
Dimension4Name = p.Dimension4Name,
Specification = p.Specification,
UnitId = p.UnitId,
UnitName = p.UnitName,
unitDecimalPlaces = p.unitDecimalPlaces,
DealunitDecimalPlaces = p.DealunitDecimalPlaces,
ProductUidName = (p.ProductUidName),
ProductUidId = p.ProductUidId,
JobOrderInspectionRequestHeaderId = p.JobOrderInspectionRequestHeaderId,
ProdOrderLineId = p.ProdOrderLineId,
});
}
public IEnumerable <JobOrderHeaderListViewModel> GetPendingJobOrdersForAC(int HeaderId, 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 InspectionRequestHeader = db.JobOrderInspectionRequestHeader.Find(HeaderId);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(InspectionRequestHeader.DocTypeId, InspectionRequestHeader.DivisionId, InspectionRequestHeader.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderBalanceForInspectionRequest
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 t4 in db.JobOrderHeader on p.JobOrderHeaderId equals t4.JobOrderHeaderId
where p.BalanceQty > 0 && p.JobWorkerId == InspectionRequestHeader.JobWorkerId && t4.ProcessId == InspectionRequestHeader.ProcessId
//&& ((string.IsNullOrEmpty(term) ? 1 == 1 : p.JobOrderNo.ToLower().Contains(term.ToLower()))
//|| (string.IsNullOrEmpty(term) ? 1 == 1 : dim1.Dimension1Name.ToLower().Contains(term.ToLower()))
//|| (string.IsNullOrEmpty(term) ? 1 == 1 : dim2.Dimension2Name.ToLower().Contains(term.ToLower()))
//|| (string.IsNullOrEmpty(term) ? 1 == 1 : t3.ProductName.ToLower().Contains(term.ToLower())))
orderby p.JobOrderNo
select new
{
DocNo = p.JobOrderNo,
JobOrderLineId = p.JobOrderLineId,
Dimension1Name = Dimension1Tab.Dimension1Name,
Dimension2Name = Dimension2Tab.Dimension2Name,
Dimension3Name = Dimension3Tab.Dimension3Name,
Dimension4Name = Dimension4Tab.Dimension4Name,
ProductName = t3.ProductName,
BalanceQty = p.BalanceQty,
SiteId = t4.SiteId,
DivisionId = t4.DivisionId,
DocTypeId = t4.DocTypeId,
});
if (!string.IsNullOrEmpty(term))
{
Query = Query.Where(m => m.DocNo.Contains(term.ToLower()) || m.Dimension1Name.Contains(term.ToLower()) ||
m.Dimension2Name.Contains(term.ToLower()) ||
m.Dimension3Name.Contains(term.ToLower()) ||
m.Dimension4Name.Contains(term.ToLower()) ||
m.ProductName.ToLower().Contains(term.ToLower()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == InspectionRequestHeader.SiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == InspectionRequestHeader.DivisionId);
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
return((from p in Query
select new JobOrderHeaderListViewModel
{
DocNo = p.DocNo,
JobOrderLineId = p.JobOrderLineId,
Dimension1Name = p.Dimension1Name,
Dimension2Name = p.Dimension2Name,
Dimension3Name = p.Dimension3Name,
Dimension4Name = p.Dimension4Name,
ProductName = p.ProductName,
BalanceQty = p.BalanceQty,
}).Take(Limiter));
}
public IQueryable <ComboBoxResult> GetPendingProductHelpList(string term, int Id)
{
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var Header = new JobOrderInspectionRequestHeaderService(db).Find(Id);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(Header.DocTypeId, CurrentDivisionId, CurrentSiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderBalanceForInspectionRequest
join jrh in db.JobOrderHeader on p.JobOrderHeaderId equals jrh.JobOrderHeaderId
join t in db.Product on p.ProductId equals t.ProductId
where jrh.ProcessId == settings.ProcessId && jrh.JobWorkerId == Header.JobWorkerId && p.BalanceQty > 0
select new
{
Product = t.ProductName,
Id = t.ProductId,
DocTypeId = jrh.DocTypeId,
SiteId = p.SiteId,
DivisionId = p.DivisionId,
}
);
if (!string.IsNullOrEmpty(term))
{
Query = Query.Where(m => m.Product.ToLower().Contains(term.ToLower()));
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == CurrentSiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == CurrentDivisionId);
}
return(from p in Query
group p by p.Id into g
orderby g.Max(m => m.Product)
select new ComboBoxResult
{
text = g.Max(m => m.Product),
id = g.Key.ToString(),
});
}
public IQueryable <ComboBoxResult> GetPendingJobOrdersForWizardFilters(string term, int Id)
{
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(Id, CurrentDivisionId, CurrentSiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderBalanceForInspectionRequest
join t in db.JobOrderHeader on p.JobOrderHeaderId equals t.JobOrderHeaderId
where p.BalanceQty > 0 && t.ProcessId == settings.ProcessId
select new
{
DocNo = p.JobOrderNo,
DocTypeId = t.DocTypeId,
SiteId = p.SiteId,
DivisionId = p.DivisionId,
JobOrderHeaderId = p.JobOrderHeaderId,
}
);
if (!string.IsNullOrEmpty(term))
{
Query = Query.Where(m => m.DocNo.ToLower().Contains(term.ToLower()));
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == CurrentSiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == CurrentDivisionId);
}
return(from p in Query
group p by p.JobOrderHeaderId into g
orderby g.Max(m => m.DocNo)
select new ComboBoxResult
{
text = g.Max(m => m.DocNo),
id = g.Key.ToString(),
});
}
public IEnumerable <JobOrderInspectionRequestLineViewModel> GetJobOrderLineForMultiSelect(JobOrderInspectionRequestFilterViewModel svm)
{
string[] ProductIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductId))
{
ProductIdArr = svm.ProductId.Split(",".ToCharArray());
}
else
{
ProductIdArr = new string[] { "NA" };
}
string[] SaleOrderIdArr = null;
if (!string.IsNullOrEmpty(svm.JobOrderId))
{
SaleOrderIdArr = svm.JobOrderId.Split(",".ToCharArray());
}
else
{
SaleOrderIdArr = new string[] { "NA" };
}
string[] ProductGroupIdArr = null;
if (!string.IsNullOrEmpty(svm.ProductGroupId))
{
ProductGroupIdArr = svm.ProductGroupId.Split(",".ToCharArray());
}
else
{
ProductGroupIdArr = new string[] { "NA" };
}
string[] Dime1IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension1Id))
{
Dime1IdArr = svm.Dimension1Id.Split(",".ToCharArray());
}
else
{
Dime1IdArr = new string[] { "NA" };
}
string[] Dime2IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension2Id))
{
Dime2IdArr = svm.Dimension2Id.Split(",".ToCharArray());
}
else
{
Dime2IdArr = new string[] { "NA" };
}
string[] Dime3IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension3Id))
{
Dime3IdArr = svm.Dimension3Id.Split(",".ToCharArray());
}
else
{
Dime3IdArr = new string[] { "NA" };
}
string[] Dime4IdArr = null;
if (!string.IsNullOrEmpty(svm.Dimension4Id))
{
Dime4IdArr = svm.Dimension4Id.Split(",".ToCharArray());
}
else
{
Dime4IdArr = new string[] { "NA" };
}
var Header = db.JobOrderInspectionRequestHeader.Find(svm.JobOrderInspectionRequestHeaderId);
var settings = new JobOrderInspectionRequestSettingsService(db).GetJobOrderInspectionRequestSettingsForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
string[] contraDocTypes = null;
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
contraDocTypes = settings.filterContraDocTypes.Split(",".ToCharArray());
}
else
{
contraDocTypes = new string[] { "NA" };
}
string[] contraSites = null;
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
contraSites = settings.filterContraSites.Split(",".ToCharArray());
}
else
{
contraSites = new string[] { "NA" };
}
string[] contraDivisions = null;
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
contraDivisions = settings.filterContraDivisions.Split(",".ToCharArray());
}
else
{
contraDivisions = new string[] { "NA" };
}
var Query = (from p in db.ViewJobOrderBalanceForInspectionRequest
join t in db.JobOrderLine on p.JobOrderLineId equals t.JobOrderLineId into table
from tab in table.DefaultIfEmpty()
join product in db.Product on p.ProductId equals product.ProductId into table2
from tab2 in table2.DefaultIfEmpty()
join jo in db.JobOrderHeader on p.JobOrderHeaderId equals jo.JobOrderHeaderId
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 uni in db.Units on tab2.UnitId equals uni.UnitId into unittable
from unittab in unittable.DefaultIfEmpty()
join dealunit in db.Units on tab.DealUnitId equals dealunit.UnitId into dealunittable
from dealunittab in dealunittable.DefaultIfEmpty()
where p.BalanceQty > 0 && p.JobWorkerId == svm.JobWorkerId && jo.ProcessId == Header.ProcessId
orderby p.OrderDate, p.JobOrderNo, tab.Sr
select new
{
BalanceQty = p.BalanceQty,
Qty = p.BalanceQty,
JobOrderDocNo = p.JobOrderNo,
ProductName = tab2.ProductName,
ProductId = p.ProductId,
JobOrderInspectionRequestHeaderId = svm.JobOrderInspectionRequestHeaderId,
JobOrderLineId = p.JobOrderLineId,
Dimension1Id = Dimension1Tab.Dimension1Id,
Dimension2Id = Dimension2Tab.Dimension2Id,
Dimension3Id = Dimension3Tab.Dimension3Id,
Dimension4Id = Dimension4Tab.Dimension4Id,
Dimension1Name = Dimension1Tab.Dimension1Name,
Dimension2Name = Dimension2Tab.Dimension2Name,
Dimension3Name = Dimension3Tab.Dimension3Name,
Dimension4Name = Dimension4Tab.Dimension4Name,
Specification = tab.Specification,
UnitId = unittab.UnitId,
UnitName = unittab.UnitName,
unitDecimalPlaces = unittab.DecimalPlaces,
DealunitDecimalPlaces = dealunittab.DecimalPlaces,
ProductUidName = (tab.ProductUidHeaderId == null ? tab.ProductUid.ProductUidName : ""),
ProductUidId = tab.ProductUidId,
JobOrderHeaderId = p.JobOrderHeaderId,
ProdOrderLineId = tab.ProdOrderLineId,
ProductGroupId = tab2.ProductGroupId,
SiteId = jo.SiteId,
DivisionId = jo.DivisionId,
DocTypeId = jo.DocTypeId,
}
);
if (!string.IsNullOrEmpty(svm.ProductId))
{
Query = Query.Where(m => ProductIdArr.Contains(m.ProductId.ToString()));
}
if (!string.IsNullOrEmpty(svm.JobOrderId))
{
Query = Query.Where(m => SaleOrderIdArr.Contains(m.JobOrderHeaderId.ToString()));
}
if (!string.IsNullOrEmpty(svm.ProductGroupId))
{
Query = Query.Where(m => ProductGroupIdArr.Contains(m.ProductGroupId.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension1Id))
{
Query = Query.Where(m => Dime1IdArr.Contains(m.Dimension1Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension2Id))
{
Query = Query.Where(m => Dime2IdArr.Contains(m.Dimension2Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension3Id))
{
Query = Query.Where(m => Dime1IdArr.Contains(m.Dimension3Id.ToString()));
}
if (!string.IsNullOrEmpty(svm.Dimension4Id))
{
Query = Query.Where(m => Dime2IdArr.Contains(m.Dimension4Id.ToString()));
}
if (!string.IsNullOrEmpty(settings.filterContraSites))
{
Query = Query.Where(m => contraSites.Contains(m.SiteId.ToString()));
}
else
{
Query = Query.Where(m => m.SiteId == Header.SiteId);
}
if (!string.IsNullOrEmpty(settings.filterContraDivisions))
{
Query = Query.Where(m => contraDivisions.Contains(m.DivisionId.ToString()));
}
else
{
Query = Query.Where(m => m.DivisionId == Header.DivisionId);
}
if (!string.IsNullOrEmpty(settings.filterContraDocTypes))
{
Query = Query.Where(m => contraDocTypes.Contains(m.DocTypeId.ToString()));
}
return((from p in Query
select new JobOrderInspectionRequestLineViewModel
{
BalanceQty = p.BalanceQty,
Qty = p.Qty,
JobOrderDocNo = p.JobOrderDocNo,
ProductName = p.ProductName,
ProductId = p.ProductId,
JobOrderInspectionRequestHeaderId = p.JobOrderInspectionRequestHeaderId,
JobOrderLineId = p.JobOrderLineId,
Dimension1Id = p.Dimension1Id,
Dimension2Id = p.Dimension2Id,
Dimension3Id = p.Dimension3Id,
Dimension4Id = p.Dimension4Id,
Dimension1Name = p.Dimension1Name,
Dimension2Name = p.Dimension2Name,
Dimension3Name = p.Dimension3Name,
Dimension4Name = p.Dimension4Name,
Specification = p.Specification,
UnitId = p.UnitId,
UnitName = p.UnitName,
unitDecimalPlaces = p.unitDecimalPlaces,
DealunitDecimalPlaces = p.DealunitDecimalPlaces,
ProductUidName = p.ProductUidName,
ProductUidId = p.ProductUidId,
JobOrderHeaderId = p.JobOrderHeaderId,
ProdOrderLineId = p.ProdOrderLineId,
}).ToList());
}
