public InventoryBll GetInventoryItem(int id)
{
var efItem = _context.Inventories.Find(id);
// var retitems = new List<ItemBll>();
var itm = _context.Items.Find(efItem.ItemId);
var shp = _context.Shops.Find(efItem.ShopId);
var retItem = new InventoryBll
{
SKU = efItem.SKU,
Available = efItem.Available,
Quantity = efItem.Quantity,
ShopId = efItem.ShopId,
ItemId = efItem.ItemId,
Items = new ItemBll
{
Id = itm.ItemId,
Name = itm.Name
},
Shops = new ShopBll
{
ShopId = shp.ShopId,
Name = shp.Name,
Address = shp.Address,
ContactNumber = shp.ContactNumber,
Lat = shp.Lat,
Long = shp.Long
}
};
return(retItem);
}
private void viewAllButton_Click(object sender, EventArgs e)
{
InventoryBll aInventoryBll = new InventoryBll();
aShop = aInventoryBll.GetAllData();
productsDataGridView.DataSource = aShop.Products;
totalQuantityTextBox.Text = aShop.TotalProducts.ToString();
}
public async Task <IActionResult> PutItem(int id, InventoryBll item)
{
if (id != item.SKU)
{
return(BadRequest());
}
await _itemService.PutInventoryItem(id, item);
return(NoContent());
}
public async Task PostInventoryItem(InventoryBll item)
{
//Todo ensure this method runs correctly im not great with async calls
var efItem = new Inventory
{
SKU = item.SKU,
Available = item.Available,
Quantity = item.Quantity,
ShopId = item.ShopId,
ItemId = item.ItemId
};
_context.Inventories.Add(efItem);
await _context.SaveChangesAsync();
}
public async Task PutInventoryItem(int id, InventoryBll item)
{
var efItem = _context.Inventories.Find(id);
// var ef = _context.Items.Find(item.Item.Id);
if (efItem != null)
{
efItem.Available = item.Available;
efItem.Quantity = item.Quantity;
efItem.ShopId = item.ShopId;
efItem.ItemId = item.ItemId;
// efItem.Item = ef;
_context.Inventories.Update(efItem);
await _context.SaveChangesAsync();
}
else
{
//Todo What happens if an item does not exist?
//Do i need to return a failed task if the item does not exist?
}
}
public async Task <ActionResult <InventoryBll> > PostItem(InventoryBll item)
{
await _itemService.PostInventoryItem(item);
return(CreatedAtAction("GetItem", new { id = item.SKU }, item));
}
public string AddModels(string UserCode, string CipherPassword, int ModelType,
string StrAccID, string Act, string Entity)
{
//Entity = System.Web.HttpUtility.UrlDecode(Entity);
string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword);
int AccYear = U8BllBase.GetBeginYear(StrAccID);
if (AccYear == 0)
{
return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号:{0}", StrAccID)));
}
int success = 0;
ModelsType mt = (ModelsType)ModelType;
switch (mt)
{
case ModelsType.Sale: // 销售订单
lock (SaleLock)
{
if (Act == "add")
{
EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity);
SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddSale(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord09: // 配送出库单(其他出库单)
lock (RdRecord09Lock)
{
if (Act == "add")
{
EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity);
RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord09(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList1: //销售退货单
case ModelsType.DispatchList4: //委托代销退货单
lock (DispatchList1Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, StrAccID, AccYear, Act, ModelsType.DispatchList1 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.DispatchList2: //销售发货单
case ModelsType.DispatchList3: //委托代销发货单
lock (DispatchList2Lock)
{
if (Act == "add")
{
EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity);
DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddDispatchList(UserCode, plainPassword, ModelType, StrAccID, AccYear, Act, ModelsType.DispatchList2 == mt ? 0 : 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_CloseBill: //收款单
lock (Ap_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Ap_Vouch: //其他应付款
lock (Ap_VouchLock)
{
if (Act == "add")
{
EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity);
Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_Vouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PO_Pomain: //采购订单
lock (PO_PomainLock)
{
if (Act == "add")
{
EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity);
PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddPO_Pomain(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01: //采购入库单
lock (RdRecord01Lock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 0, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.PayAp_CloseBill: //付款单
lock (PayAp_CloseBillLock)
{
if (Act == "add")
{
EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity);
Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.ST_AppTransVouch: //调拨申请单
lock (ST_AppTransVouchLock)
{
if (Act == "add")
{
EntityST_AppTransVouch entity = JsonConvert.DeserializeObject <EntityST_AppTransVouch>(Entity);
ST_AppTransVouchBll bll = new ST_AppTransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddST_AppTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.TransVouch: //调拨单
lock (TransVouchLock)
{
if (Act == "add")
{
EntityTransVouch entity = JsonConvert.DeserializeObject <EntityTransVouch>(Entity);
TransVouchBll bll = new TransVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Vendor: //供应商
lock (VendorLock)
{
if (Act == "add")
{
EntityVendor entity = JsonConvert.DeserializeObject <EntityVendor>(Entity);
VendorBll bll = new VendorBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddVendor(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.CheckVouch: //盘点单
lock (VendorLock)
{
if (Act == "add")
{
EntityCheckVouchHead entity = JsonConvert.DeserializeObject <EntityCheckVouchHead>(Entity);
CheckVouchBll bll = new CheckVouchBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCheckVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.InventoryClass: //存货分类
lock (InventoryClassLock)
{
if (Act == "add")
{
EntityInventoryClass entity = JsonConvert.DeserializeObject <EntityInventoryClass>(Entity);
InventoryClassBll bll = new InventoryClassBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventoryClass(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Inventory: //存货档案
lock (InventoryLock)
{
if (Act == "add")
{
EntityInventory entity = JsonConvert.DeserializeObject <EntityInventory>(Entity);
InventoryBll bll = new InventoryBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddInventory(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.WareHouse: //仓库档案
lock (WareHouseLock)
{
if (Act == "add")
{
EntityWareHouse entity = JsonConvert.DeserializeObject <EntityWareHouse>(Entity);
WareHouseBll bll = new WareHouseBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddWareHouse(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.Customer: //客户档案
lock (CustomerLock)
{
if (Act == "add")
{
EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity);
CustomerBll bll = new CustomerBll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddCustomer(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
case ModelsType.RdRecord01T: //红字采购入库单
lock (RdRecord01TLock)
{
if (Act == "add")
{
EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity);
RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword);
var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 1, entity, out success);
return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result));
}
break;
}
}
return(ControllerHelp.GetReturnStr(0, "AddModels中没有找到可对应的操作项"));
}
public Task PutInventoryItem(int id, InventoryBll item)
{
return(_dataService.PutInventoryItem(id, item));
}
public Task PostInventoryItem(InventoryBll item)
{
return(_dataService.PostInventoryItem(item));
}