public IActionResult UomConversionDelete(int uomConversionSk)
{
System.Console.WriteLine("-----------------------------------UomConversionDelete--------------------------------------");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
bool isDeleteOk = true;
UomConversion uomConversionInDb = uomConversionHelper.GetUomConversionBySk(uomConversionSk);
if (uomConversionInDb == null)
{
// Uom not found in Db. This is an exception...
isDeleteOk = false;
}
if (isDeleteOk)
{
System.Console.WriteLine("-----------------------------------UomConversionDelete-IsDeleteId=true-------------------------------------");
// Delete Uom
dbContext.UomConversion.Remove(uomConversionInDb);
dbContext.SaveChanges();
}
else
{
System.Console.WriteLine("-----------------------------------UomConversionDelete-IsDeleteId=false-------------------------------------");
}
return(RedirectToAction("UomConversionNewListView"));
}
public ActionResult _UomConvertEdit(UomConversion uomConv)
{
if (uomConv.ItemCode != null)
{
Item item = base.genericMgr.FindById <Item>(uomConv.ItemCode);
uomConv.Item = item;
}
else
{
uomConv.Item = null;
}
ModelState.Remove("Item.Code");
ModelState.Remove("Item.Description");
if (ModelState.IsValid)
{
base.genericMgr.Update(uomConv);
SaveSuccessMessage(Resources.MD.UomConvert.UomConvert_Updated);
}
////return new RedirectToRouteResult(new RouteValueDictionary
//// {
//// { "action", "_UomConvertEdit" },
//// { "controller", "Uom" },
//// { "id", uomConv.Id }
//// });
return(PartialView(uomConv));
}
protected void ODS_GV_UomConversion_OnDeleting(object sender, ObjectDataSourceMethodEventArgs e)
{
UomConversion uomConversion = (UomConversion)e.InputParameters[0];
UomConversion delUomConversion = TheUomConversionMgr.LoadUomConversion(uomConversion.Id);
itemMessage[0] = delUomConversion.Item == null ? string.Empty : delUomConversion.Item.Code;
itemMessage[1] = delUomConversion.BaseQty.ToString();
itemMessage[2] = delUomConversion.BaseUom.Code;
itemMessage[3] = delUomConversion.AlterQty.ToString();
itemMessage[4] = delUomConversion.AlterUom.Code;
}
protected override void DeleteObject(object obj)
{
UomConversion uomConversion = (UomConversion)obj;
UomConversion newUomConversion = this.uomConversionMgr.LoadUomConversion(uomConversion.Item.Code, uomConversion.AlterUom.Code, uomConversion.BaseUom.Code);
if (newUomConversion != null)
{
this.uomConversionMgr.DeleteUomConversion(newUomConversion.Id);
}
}
public IActionResult UomNewSave(Uom uom)
{
System.Console.WriteLine("-----------------------------------UomNewSave--------------------------------------");
bool isValid = ModelState.IsValid;
if (isValid)
{
var uomIdInDb = dbContext.Uom.FirstOrDefault(u => u.UomId == uom.UomId);
if (uomIdInDb != null)
{
ModelState.AddModelError("UomId", "Uom Id already exists.");
isValid = false;
}
else
{
var uomNameInDb = dbContext.Uom.FirstOrDefault(u => u.UomName == uom.UomName);
if (uomNameInDb != null)
{
ModelState.AddModelError("UomName", "Uom Name already exists.");
isValid = false;
}
}
}
if (isValid)
{
// Add new Uom
DateTime now = DateTime.Now;
uom.CreatedAt = now;
uom.UpdatedAt = now;
dbContext.Add(uom);
dbContext.SaveChanges();
// Add the 1-1 Uom Conversion row for the new Uom
var uomInDb = dbContext.Uom.FirstOrDefault(u => u.UomId == uom.UomId);
UomConversion uomConversion = new UomConversion {
UomTypeSk = uomInDb.UomTypeSk, ConvertFromUomSk = uomInDb.UomSk, ConvertToUomSk = uomInDb.UomSk, ConversionFactor = 1, CreatedAt = now, UpdatedAt = now
};
dbContext.Add(uomConversion);
dbContext.SaveChanges();
return(RedirectToAction("UomNewListView"));
}
else
{
// New was invalid, route back to Uom New / List view
setLayoutViewBag();
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
return(View("UomNewListView", uom));
}
}
protected void ODS_UomConversion_Inserting(object source, ObjectDataSourceMethodEventArgs e)
{
UomConversion uomConversion = (UomConversion)e.InputParameters[0];
string itemCode = ((Controls_TextBox)(this.FV_UomConversion.FindControl("tbItemCode"))).Text;
string altUom = ((Controls_TextBox)(this.FV_UomConversion.FindControl("tbAltUom"))).Text;
string baseUom = ((Controls_TextBox)(this.FV_UomConversion.FindControl("tbBaseUom"))).Text;
itemMessage[0] = itemCode;
itemMessage[1] = uomConversion.BaseQty.ToString();
itemMessage[2] = baseUom;
itemMessage[3] = uomConversion.AlterQty.ToString();
itemMessage[4] = altUom;
//if (itemCode == null || itemCode.Trim() == string.Empty)
//{
// ShowWarningMessage("MasterData.UomConversion.Required.itemCode", "");
// e.Cancel = true;
// return;
//}
if (altUom == null || altUom.Trim() == string.Empty)
{
ShowWarningMessage("MasterData.UomConversion.Required.altUom", "");
e.Cancel = true;
return;
}
if (altUom == baseUom)
{
ShowWarningMessage("MasterData.UomConversion.Same.Uom", baseUom);
e.Cancel = true;
return;
}
if (baseUom == null || baseUom.Trim() == string.Empty)
{
ShowWarningMessage("MasterData.UomConversion.Required.baseUom", "");
e.Cancel = true;
return;
}
if (TheUomConversionMgr.LoadUomConversion(itemCode, altUom, baseUom) == null && TheUomConversionMgr.LoadUomConversion(itemCode, baseUom, altUom) == null)
{
uomConversion.Item = TheItemMgr.LoadItem(itemCode);
uomConversion.AlterUom = TheUomMgr.LoadUom(altUom);
uomConversion.BaseUom = TheUomMgr.LoadUom(baseUom);
ShowSuccessMessage("MasterData.UomConversion.AddUomConversion.Successfully", itemMessage);
}
else
{
e.Cancel = true;
ShowErrorMessage("MasterData.UomConversion.AddUomConversion.Error", itemMessage);
return;
}
}
//--------------------------------------------------------------
// Select and return the UomConversion related to the passed uomConversionSk
public UomConversion GetUomConversionBySk(int uomConversionSk)
{
System.Console.WriteLine("------------------------------------------GetUomConversionBySk------------------------------------------");
UomConversion uomConversion = (from u in dbContext.UomConversion
where u.UomConversionSk == uomConversionSk
select u)
.Include("UomType")
.Include("ConvertFromUom")
.Include("ConvertToUom")
.FirstOrDefault();
return(uomConversion);
}
public ActionResult _UomConvertNew(UomConversion uomConversion)
{
if (ModelState.IsValid)
{
if (base.genericMgr.FindAll <long>(uomConvertDuiplicateVerifyStatement, new object[] { uomConversion.Id })[0] > 0)
{
SaveErrorMessage(Resources.ErrorMessage.Errors_Existing_Code);
}
else if (uomConversion.BaseUom == uomConversion.AlterUom)
{
SaveErrorMessage(Resources.MD.UomConvert.Errors_Existing_Uom);
}
else if (uomConversion.ItemCode == null)
{
if (base.genericMgr.FindAll <long>(uomConvertIsExistAndItemIsNull, new object[] { uomConversion.BaseUom, uomConversion.AlterUom })[0] > 0)
{
SaveErrorMessage(Resources.MD.UomConvert.Errors_Existing_UomConv);
}
else
{
base.genericMgr.Create(uomConversion);
SaveSuccessMessage(Resources.MD.UomConvert.UomConvert_Added);
return(RedirectToAction("_UomConvertEdit/" + uomConversion.Id));
}
}
else
{
if (base.genericMgr.FindAll <Item>("from Item where Code=?", uomConversion.ItemCode).Count < 1)
{
SaveErrorMessage(Resources.MD.UomConvert.Errors_NotExisting_Item);
}
else
{
if (base.genericMgr.FindAll <long>(uomConvertIsExist, new object[] { uomConversion.ItemCode, uomConversion.BaseUom, uomConversion.AlterUom })[0] > 0)
{
SaveErrorMessage(Resources.MD.UomConvert.Errors_Existing_UomConv);
}
else
{
Item item = base.genericMgr.FindById <Item>(uomConversion.ItemCode);
uomConversion.Item = item;
base.genericMgr.Create(uomConversion);
SaveSuccessMessage(Resources.MD.UomConvert.UomConvert_Added);
return(RedirectToAction("_UomConvertEdit/" + uomConversion.Id));
}
}
}
}
return(PartialView(uomConversion));
}
public IActionResult UomConversionNewSave(UomConversion uomConversion)
{
System.Console.WriteLine("-----------------------------------UomConversionNewSave(UomConversion uomConversion):1--------------------------------------");
bool isValid = ModelState.IsValid;
if (isValid)
{
var uomConversionInDb = (from u in dbContext.UomConversion
where u.ConvertFromUomSk == uomConversion.ConvertFromUomSk
where u.ConvertToUomSk == uomConversion.ConvertToUomSk
select u).FirstOrDefault();
if (uomConversionInDb != null)
{
ModelState.AddModelError("ConvertFromUomSK", "From / To Uom conversion already exists.");
isValid = false;
}
}
if (isValid)
{
// Add new UomConversion
DateTime now = DateTime.Now;
uomConversion.CreatedAt = now;
uomConversion.UpdatedAt = now;
dbContext.Add(uomConversion);
dbContext.SaveChanges();
dbContext.SaveChanges();
return(RedirectToAction("UomConversionNewListview"));
}
else
{
System.Console.WriteLine("-----------------------------------UomConversionNewSave(UomConversion uomConversion):2--------------------------------------");
System.Console.WriteLine($"{uomConversion.UomTypeSk}");
// New was invalid, route back to UomConversion New / List view
setLayoutViewBag();
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
UomType uomType = uomTypeHelper.GetUomTypeBySk(uomConversion.UomTypeSk);
System.Console.WriteLine($"{uomType.UomTypeName}");
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(uomType.UomTypeName);
return(View("UomConversionNewListView", uomConversion));
}
}
private object Deserialize(DssImportHistory dssImportHistory, bool isUpdate)
{
UomConversion uomConversion = new UomConversion();
uomConversion.BaseUom = this.uomMgr.CheckAndLoadUom(dssImportHistory[1]); //基本单位
uomConversion.AlterUom = this.uomMgr.CheckAndLoadUom(dssImportHistory[2]); //替代单位
uomConversion.Item = this.itemMgr.CheckAndLoadItem(dssImportHistory[3]); //零件号
if (isUpdate)
{
//基本单位:G,替代单位:KG,换算因子:1000 => 1 KG = 1000 G
uomConversion.BaseQty = decimal.Parse(dssImportHistory[4]);//换算因子
uomConversion.AlterQty = 1;
}
return(uomConversion);
}
protected override void CreateOrUpdateObject(object obj)
{
UomConversion uomConversion = (UomConversion)obj;
UomConversion newUomConversion = this.uomConversionMgr.LoadUomConversion(uomConversion.Item.Code, uomConversion.AlterUom.Code, uomConversion.BaseUom.Code);
if (newUomConversion == null)
{
this.uomConversionMgr.CreateUomConversion(uomConversion);
}
else
{
CloneHelper.CopyProperty(uomConversion, newUomConversion, this.fields);
this.uomConversionMgr.UpdateUomConversion(newUomConversion);
}
}
protected void ODS_GV_UomConversion_OnUpdating(object source, ObjectDataSourceMethodEventArgs e)
{
UomConversion uomConversion = (UomConversion)e.InputParameters[0];
UomConversion oldConversion = TheUomConversionMgr.LoadUomConversion(uomConversion.Id);
uomConversion.BaseUom = oldConversion.BaseUom;
uomConversion.AlterUom = oldConversion.AlterUom;
uomConversion.Item = oldConversion.Item;
itemMessage[0] = oldConversion.Item == null ? string.Empty : oldConversion.Item.Code;
itemMessage[1] = uomConversion.BaseQty.ToString();
itemMessage[2] = oldConversion.BaseUom.Code;
itemMessage[3] = uomConversion.AlterQty.ToString();
itemMessage[4] = oldConversion.AlterUom.Code;
ShowSuccessMessage("MasterData.UomConversion.UpdateUomConversion.Successfully", itemMessage);
}
public ActionResult _UomConvertEdit(int?id)
{
if (!id.HasValue)
{
return(HttpNotFound());
}
else
{
UomConversion uomConv = base.genericMgr.FindById <UomConversion>(id);
if (uomConv.Item != null)
{
uomConv.ItemCode = uomConv.Item.Code;
}
return(PartialView(uomConv));
}
}
public IActionResult UomConversionEdit(int uomConversionSk)
{
System.Console.WriteLine("-----------------------------------UomConversionEdit(int uomConversionSk):1--------------------------------------");
System.Console.WriteLine($"uomConversionSk: {uomConversionSk}");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
setLayoutViewBag();
UomConversion uomConversion = uomConversionHelper.GetUomConversionBySk(uomConversionSk);
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(uomConversion.UomType.UomTypeName);
return(View("UomConversionEdit", uomConversion));
}
public decimal ConvertUomQty(string itemCode, string sourceUomCode, decimal sourceQty, string targetUomCode)
{
if (sourceUomCode == targetUomCode)
{
return(sourceQty);
}
UomConversion uomConversion = this.LoadUomConversion(itemCode, sourceUomCode, targetUomCode);
if (uomConversion != null)
{
return(sourceQty * uomConversion.BaseQty / uomConversion.AlterQty);
}
else
{
uomConversion = this.LoadUomConversion(itemCode, targetUomCode, sourceUomCode);
if (uomConversion != null)
{
return(sourceQty * uomConversion.AlterQty / uomConversion.BaseQty);
}
else
{
uomConversion = this.LoadUomConversion(null, sourceUomCode, targetUomCode);
if (uomConversion != null)
{
return(sourceQty * uomConversion.BaseQty / uomConversion.AlterQty);
}
else
{
uomConversion = this.LoadUomConversion(null, targetUomCode, sourceUomCode);
if (uomConversion != null)
{
return(sourceQty * uomConversion.AlterQty / uomConversion.BaseQty);
}
else
{
throw new BusinessErrorException("UomConversion.Error.NotFound", itemCode, sourceUomCode, targetUomCode);
}
}
}
}
}
public IActionResult UomConversionNewListView(UomConversion uomConversion)
{
System.Console.WriteLine("-----------------------------------Post:UomConversionNewListView(UomConversion uomConversion):1--------------------------------------");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
System.Console.WriteLine("-----------------------------------Post:UomConversionNewListView(UomConversion uomConversion):2--------------------------------------");
UomType uomType = uomTypeHelper.GetUomTypeBySk(uomConversion.UomTypeSk);
string filterText = uomType.UomTypeName;
setLayoutViewBag();
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(filterText);
return(View("UomConversionNewListView", uomConversion));
}
public IActionResult UomConversionNewListView()
{
System.Console.WriteLine("-----------------------------------Get:UomConversionNewListView():1--------------------------------------");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
setLayoutViewBag();
UomConversion uomConversion = new UomConversion {
UomTypeSk = 2, ConversionFactor = 1
};
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
UomType uomType = uomTypeHelper.GetUomTypeBySk(2);
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(uomType.UomTypeName);
return(View("UomConversionNewListView", uomConversion));
}
public virtual void DeleteUomConversion(UomConversion entity)
{
Delete(entity);
}
public virtual void UpdateUomConversion(UomConversion entity)
{
Update(entity);
}
public virtual void CreateUomConversion(UomConversion entity)
{
Create(entity);
}
public decimal ConvertItemUomQty(string itemCode, string sourceUomCode, decimal sourceQty, string targetUomCode)
{
if (sourceUomCode == targetUomCode || sourceQty == 0)
{
return(sourceQty);
}
#region 第一次转换单位，使用Item定义的单位转换
DetachedCriteria criteria = DetachedCriteria.For <UomConversion>();
criteria.Add(Expression.Eq("Item.Code", itemCode));
IList <UomConversion> SpecifiedItemUomConversionList = genericMgr.FindAll <UomConversion>(criteria);
UomConversion uomConversion = (from conv in SpecifiedItemUomConversionList
where (conv.BaseUom == sourceUomCode && conv.AlterUom == targetUomCode) ||
(conv.BaseUom == targetUomCode && conv.AlterUom == sourceUomCode)
select conv).FirstOrDefault();
if (uomConversion != null)
{
if (uomConversion.BaseUom == sourceUomCode)
{
return(sourceQty * uomConversion.AlterQty / uomConversion.BaseQty);
}
else
{
return(sourceQty * uomConversion.BaseQty / uomConversion.AlterQty);
}
}
#endregion
#region 第二次转换单位，使用通用的单位转换
criteria = DetachedCriteria.For <UomConversion>();
criteria.Add(Expression.IsNull("Item"));
IList <UomConversion> genericItemUomConversionList = genericMgr.FindAll <UomConversion>(criteria);
uomConversion = (from conv in genericItemUomConversionList
where (conv.BaseUom == sourceUomCode && conv.AlterUom == targetUomCode) ||
(conv.BaseUom == targetUomCode && conv.AlterUom == sourceUomCode)
select conv).FirstOrDefault();
if (uomConversion != null)
{
if (uomConversion.BaseUom == sourceUomCode)
{
return(sourceQty * uomConversion.AlterQty / uomConversion.BaseQty);
}
else
{
return(sourceQty * uomConversion.BaseQty / uomConversion.AlterQty);
}
}
#endregion
#region 无级单位转换
List <UomConversion> mergedItemUomConversionList = new List <UomConversion>();
mergedItemUomConversionList.AddRange(SpecifiedItemUomConversionList);
mergedItemUomConversionList.AddRange(genericItemUomConversionList);
//思路：用sourceUomCode、targetUomCode分别和uomConversion.BaseUom、uomConversion.AlterUom匹配
//总共4种情况，循环嵌套往下查找。
//每次嵌套需要过滤掉已经用过得uomConversion来防止死循环。
decimal?targetQty = NestConvertItemUomQty(mergedItemUomConversionList, sourceUomCode, targetUomCode, sourceQty, false);
if (!targetQty.HasValue)
{
targetQty = NestConvertItemUomQty(mergedItemUomConversionList, targetUomCode, sourceUomCode, sourceQty, true);
}
if (targetQty.HasValue)
{
return(targetQty.Value);
}
else
{
throw new BusinessException(Resources.ErrorMessage.Errors_Item_UomConvertionNotFound, itemCode, sourceUomCode, targetUomCode);
}
#endregion
}
public virtual void DeleteUomConversion(UomConversion entity)
{
entityDao.DeleteUomConversion(entity);
}
public virtual void UpdateUomConversion(UomConversion entity)
{
entityDao.UpdateUomConversion(entity);
}
public virtual void CreateUomConversion(UomConversion entity)
{
entityDao.CreateUomConversion(entity);
}