private string removeInventory(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbInventory inventory = amscm.tbInventory.Find(context.Request.Form["cnvcInvCode"]); amscm.tbInventory.Remove(inventory); AMSCM.Models.tbGoods tbGoods = amscm.tbGoods.Find(inventory.cnvcInvCode); if (tbGoods != null) { amscm.tbGoods.Remove(tbGoods); } amscm.SaveChanges(); } } catch (ArgumentNullException aex) { ExceptionPolicy.HandleException(aex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, aex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
public static void SyncGoods(AMSCM.Models.tbInventory inv, AMSCM.Models.AMSCM amscm) { AMSCM.Models.tbGoods tbGoods = amscm.tbGoods.Find(inv.cnvcInvCode); if (inv.cnbSale) { if (tbGoods == null) { AMSCM.Models.tbGoods gs = new AMSCM.Models.tbGoods(); gs.vcGoodsID = inv.cnvcInvCode; gs.vcGoodsName = inv.cnvcInvName; gs.vcSpell = Helper.GetChineseSpell(inv.cnvcInvName); gs.nPrice = Convert.ToDecimal(inv.cnfRetailPrice); gs.nRate = 0; gs.iIgValue = -1; gs.cNewFlag = "0"; gs.vcComments = "存货档案添加同步"; amscm.tbGoods.Add(gs); } else { if (tbGoods.vcGoodsName != inv.cnvcInvName) { tbGoods.vcGoodsName = inv.cnvcInvName; tbGoods.vcSpell = Helper.GetChineseSpell(inv.cnvcInvName); } if (inv.cnfRetailPrice > 0) { tbGoods.nPrice = Convert.ToDecimal(inv.cnfRetailPrice); } tbGoods.vcComments = "存货档案修改同步"; } } else { if (tbGoods != null) { amscm.tbGoods.Remove(tbGoods); } } }
private string updateInventory(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbInventory inventory = amscm.tbInventory.Find(context.Request.Form["cnvcInvCode"]); inventory.cnbProductBill = context.Request.Form["cnbProductBill"] == "on" ? true : false;// Convert.ToBoolean(context.Request.Form["cnbProductBill"]); //inventory.cnvcInvCode = context.Request.Form["cnvcInvCode"]; inventory.cnvcInvName = context.Request.Form["cnvcInvName"]; inventory.cnvcInvStd = context.Request.Form["cnvcInvStd"]; //inventory.cnvcInvCCode = context.Request.Form["cnvcInvCCode"]; inventory.cnbSale = context.Request.Form["cnbSale"] == "on"?true:false; //Convert.ToBoolean(context.Request.Form["cnbSale"]); inventory.cnbPurchase = context.Request.Form["cnbPurchase"] == "on"?true:false; //Convert.ToBoolean(context.Request.Form["cnbPurchase"]); inventory.cnbSelf = context.Request.Form["cnbSelf"] == "on"?true:false; //Convert.ToBoolean(context.Request.Form["cnbSelf"]); inventory.cnbComsume = context.Request.Form["cnbComsume"] == "on" ? true : false; // Convert.ToBoolean(context.Request.Form["cnbComsume"]); if (context.Request.Form["cniInvCCost"] != "") { inventory.cniInvCCost = Convert.ToDecimal(context.Request.Form["cniInvCCost"]); } if (context.Request.Form["cniInvNCost"] != "") { inventory.cniInvNCost = Convert.ToDecimal(context.Request.Form["cniInvNCost"]); } if (context.Request.Form["cniSafeNum"] != "") { inventory.cniSafeNum = Convert.ToDecimal(context.Request.Form["cniSafeNum"]); } if (context.Request.Form["cniLowSum"] != "") { inventory.cniLowSum = Convert.ToDecimal(context.Request.Form["cniLowSum"]); } if (context.Request.Form["cndSDate"] != "") { inventory.cndSDate = Convert.ToDateTime(context.Request.Form["cndSDate"]); } if (context.Request.Form["cndEDate"] != "") { inventory.cndEDate = Convert.ToDateTime(context.Request.Form["cndEDate"]); } inventory.cnvcCreatePerson = context.Request.Form["cnvcCreatePerson"]; inventory.cnvcModifyPerson = context.Request.Form["cnvcModifyPerson"]; //if (context.Request.Form["cndModifyDate"] != "") inventory.cndModifyDate = DateTime.Now;//Convert.ToDateTime(context.Request.Form["cndModifyDate"]); inventory.cnvcValueType = context.Request.Form["cnvcValueType"]; inventory.cnvcGroupCode = context.Request.Form["cnvcGroupCode"]; inventory.cnvcComUnitCode = context.Request.Form["cnvcComUnitCode"]; inventory.cnvcSAComUnitCode = context.Request.Form["cnvcSAComUnitCode"]; inventory.cnvcPUComUnitCode = context.Request.Form["cnvcPUComUnitCode"]; inventory.cnvcSTComUnitCode = context.Request.Form["cnvcSTComUnitCode"]; //inventory.cnvcProduceUnitCode = context.Request.Form["cnvcProduceUnitCode"]; if (context.Request.Form["cnfRetailPrice"] != "") { inventory.cnfRetailPrice = Convert.ToDecimal(context.Request.Form["cnfRetailPrice"]); } inventory.cnvcShopUnitCode = context.Request.Form["cnvcShopUnitCode"]; inventory.cnvcFeel = context.Request.Form["cnvcFeel"]; inventory.cnvcOrganise = context.Request.Form["cnvcOrganise"]; inventory.cnvcColor = context.Request.Form["cnvcColor"]; inventory.cnvcTaste = context.Request.Form["cnvcTaste"]; if (context.Request.Form["cnnExpire"] != "") { inventory.cnnExpire = Convert.ToInt32(context.Request.Form["cnnExpire"]); } if (context.Request.Form["cnnDue"] != "") { inventory.cnnDue = Convert.ToInt32(context.Request.Form["cnnDue"]); } ServiceHelper.SyncGoods(inventory, amscm); amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }