private string GetPartNoFromCustPartNo(string custPartNo, string customerNo)
{
if (string.IsNullOrEmpty(custPartNo))
{
return(string.Empty);
}
using (CHubEntities db = new CHubEntities())
{
G_CATALOG_CUSTOMER_PART_BLL custBLL = new G_CATALOG_CUSTOMER_PART_BLL(db);
string PartNo = custBLL.GetPartNoFromCustPartNo(custPartNo, customerNo);
if (string.IsNullOrEmpty(PartNo))
{
G_PART_DESCRIPTION_BLL partBLL = new G_PART_DESCRIPTION_BLL(db);
if (partBLL.IsPartNoExist(custPartNo))
{
return(custPartNo);
}
else
{
return(string.Empty);
}
}
return(PartNo);
}
}
public string CheckOrderLineItemAction(OrderLineCheckArg olArg)
{
//reset
olArg.olItem.PartNo = string.Empty;
olArg.olItem.AltAVLCheckColor = string.Empty;
olArg.olItem.PriAVLCheckColor = string.Empty;
olArg.olItem.PartNoPlaceHolder = string.Empty;
olArg.olItem.PriAVLCheck = null;
olArg.olItem.AltAVLCheck = null;
olArg.olItem.DescCN = string.Empty;
olArg.olItem.Description = string.Empty;
olArg.olItem.ItemBackColor = string.Empty;
olArg.olItem.WarningMsg = string.Empty;
olArg.olItem.WarningColor = string.Empty;
olArg.olItem.LastCheckNo = olArg.olItem.CustomerPartNo;
olArg.olItem.LastQty = olArg.olItem.Qty;
string msg = string.Empty;
olArg.olItem.PartNo = GetPartNoFromCustPartNo(olArg.olItem.CustomerPartNo, olArg.customerNo);
olArg.olItem.PartNoPlaceHolder = string.Empty;
if (string.IsNullOrEmpty(olArg.olItem.PartNo))
{
olArg.olItem.PartNoPlaceHolder = "Can't find Part NO";
olArg.olItem.ItemBackColor = CHubConstValues.ErrorColor;
return(null);
}
else
{
CHubEntities db = new CHubEntities();
G_PART_DESCRIPTION_BLL pDescBLL = new G_PART_DESCRIPTION_BLL(db);
//Get description
G_PART_DESCRIPTION pDesc = pDescBLL.GetPartDescription(olArg.olItem.PartNo);
olArg.olItem.Description = pDesc.DESCRIPTION;
olArg.olItem.DescCN = pDesc.DESC_CN;
//check inactive status
if (pDesc.PART_STATUS == PartStatusEnum.I.ToString())
{
olArg.olItem.WarningMsg = string.Format("SSC:{0},", pDesc.CURRENT_SALES_STATUS_CODE);
//olArg.olItem.WarningColor = CHubConstValues.WarningColor;
}
string usingSysID = olArg.primarySysID;
//Do AVL check
if (olArg.olItem.Qty > 0)
{
if (string.IsNullOrEmpty(olArg.primarySysID) || string.IsNullOrEmpty(olArg.primaryWareHouse))
{
msg = "No Primary SysID and WareHouse information";
}
G_NETAVL_BLL netBLL = new G_NETAVL_BLL(db);
//Primary AVL check
decimal priNet = netBLL.GetSpecifyNETAVL(olArg.primarySysID, olArg.olItem.PartNo, olArg.primaryWareHouse);
if (priNet == 0)
{
olArg.olItem.PriAVLCheckColor = CHubConstValues.NoStockColor;
}
else if (priNet >= olArg.olItem.Qty)
{
olArg.olItem.PriAVLCheckColor = CHubConstValues.SatisfyStockColor;
}
else
{
olArg.olItem.PriAVLCheckColor = CHubConstValues.PartialStockColor;
}
olArg.olItem.PriAVLCheck = priNet;
//if primary is no enough do Alt AVL check
if (priNet < olArg.olItem.Qty)
{
if (!(string.IsNullOrEmpty(olArg.altSysID) || string.IsNullOrEmpty(olArg.altWareHosue)))
{
decimal altNet = netBLL.GetSpecifyNETAVL(olArg.altSysID, olArg.olItem.PartNo, olArg.altWareHosue);
if (altNet == 0)
{
olArg.olItem.AltAVLCheckColor = CHubConstValues.NoStockColor;
}
else if (altNet >= olArg.olItem.Qty)
{
olArg.olItem.AltAVLCheckColor = CHubConstValues.SatisfyStockColor;
usingSysID = olArg.altSysID;
}
else
{
olArg.olItem.AltAVLCheckColor = CHubConstValues.PartialStockColor;
}
olArg.olItem.AltAVLCheck = altNet;
}
}
}
//Do G_OESALES_CATALOG_VALIDATION
G_OESALES_CATALOG_VALIDATION oeSaleValidation = new G_OESALES_CATALOG_VALIDATION(usingSysID, olArg.olItem.PartNo, olArg.olItem.Qty);
olArg.olItem.WarningMsg += oeSaleValidation.ValidationAction();
if (!string.IsNullOrEmpty(olArg.olItem.WarningMsg))
{
olArg.olItem.WarningColor = CHubConstValues.WarningColor;
}
}
return(msg);
}
public ActionResult FuzzyQueryParNo(string fuzzypartNo)
{
G_PART_DESCRIPTION_BLL gpBLL = new G_PART_DESCRIPTION_BLL();
return(Json(gpBLL.fuzzyqueryByPartNo(fuzzypartNo)));
}
