/// <summary> /// 添加物品 /// </summary> /// <param name="g"></param> /// <returns></returns> public static bool AddGoods(Entity.Goods g) { if (DAL.GoodsDAL.AddGoods(g) > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新物品数量物品数量,价格 /// </summary> /// <returns></returns> public static bool UpAdd(Entity.Goods g) { if (DAL.GoodsDAL.UpAdd(g) > 0) { return(true); } else { return(false); } }
public async Task <IActionResult> Add(long?id) { CreateOrEditDto s = new CreateOrEditDto(); List <Entity.Image> imageList = new List <Entity.Image>(); Entity.Goods a = new Entity.Goods(); if (id != null) { a = await _AppService.GetByIdAsync((long)id); imageList = await _imgAppService.GetList((long)id, (int)ImageType.商品图片); string imgs = "", config = ""; for (int i = 0; i < imageList.Count; i++) { imgs += $"\'{imageList[i].Url.ToString()}\',"; //config += string.Format("{" + "key: 'item{0}',url:'{1}',size:{2}" + "}", // imageList[i].ToString(), imageList[i].Url, imageList[i].Size); config += "{img:'" + imageList[i].Url + "', key: '" + imageList[i].Id.ToString() + "',url:'/common/deleteimg'},"; } ViewBag.Images = imgs; ViewBag.Config = config; } s.Goods = a; s.ImageList = imageList; var cat = _catAppService.GetCategoryDropDownList(AbpSession.TenantId, 0); ViewData.Add("Category", new SelectList(cat, "Id", "Title")); var b = _brandAppService.GetMultiSelect(); ViewData.Add("Brand", new SelectList(b, "Id", "Title")); var storeDropDown = (await _storeAppService.GetDropDown()); ViewData.Add("ChainStore", new SelectList(storeDropDown, "Id", "Name")); IList <SelectListItem> listItem = new List <SelectListItem>(); Array values = System.Enum.GetValues(typeof(Entity.GoodsType)); foreach (int item in values) { listItem.Add(new SelectListItem { Value = item.ToString(), Text = L(System.Enum.GetName(typeof(Entity.GoodsType), item)) }); } ViewData.Add("GoodsType", new SelectList(listItem, "Value", "Text")); return(View(s)); }
/// <summary> /// load goods from database, using global one reference of entity.map /// </summary> /// <returns></returns> public List <Entity.Goods> LoadGoods() { DAL.GoodDA.IGoodDA goodDA = new DAL.GoodDA.GoodDAO(); List <DAL.Goods> glist = goodDA.GetGoods(); List <Entity.Goods> resList = new List <Entity.Goods>(); foreach (DAL.Goods g in glist) { g.Batch = g.Batch.Trim(); g.Model = g.Model.Trim(); g.Name = g.Name.Trim(); g.ProductId = g.ProductId.Trim(); g.BarCode = g.BarCode.Trim(); Entity.Goods tmp = new Entity.Goods(); tmp.DAL_SetGood(g); resList.Add(tmp); } _map.Goods = resList; _DAL_GoodList = glist; return(resList); }
public void AddGoods(Model.Goods goods) { if (goods == null) { throw new Exception("商品信息无效"); } if (string.IsNullOrEmpty(goods.Name)) { throw new Exception("商品名称无效"); } var entity = new Entity.Goods() { Name = goods.Name, ClassID = goods.ClassID, Disable = false, UnitID = goods.UnitID }; var dbContext = ServiceProvider.GetDbcontext <IPurocumentDbcontext>(); dbContext.Add(entity); dbContext.SaveChanges(); }
/// <summary> /// 查询总数 /// </summary> /// <param name="g"></param> /// <returns></returns> public static int SearchCount(Entity.Goods g) { string sql = "select GCount from Goods where GID=" + g.gID + ""; return((int)DBHelper.GetScalar(sql)); }
/// <summary> /// 物品详情 /// </summary> /// <returns></returns> public static System.Data.DataTable LoadGoodOnly(Entity.Goods g) { return(DAL.GoodsDAL.LoadGoodOnly(g)); }
/// <summary> /// 查询总数 /// </summary> /// <param name="g"></param> /// <returns></returns> public static int SearchCount(Entity.Goods g) { return(EDAL.GoodsDAL.SearchCount(g)); }
/// <summary> /// 更新物品数量物品数量,价格 /// </summary> /// <returns></returns> public static int UpAdd(Entity.Goods g) { string sql = "update Goods set GCount='" + g.gCount + "',GPrice='" + g.gPrice + "' where GID=" + g.gID + ""; return(DBHelper.GetLine(sql)); }
/// <summary> /// 添加物品 /// </summary> /// <param name="g"></param> /// <returns></returns> public static int AddGoods(Entity.Goods g) { string sql = "insert into Goods values('" + g.gName + "','" + g.gCount + "','" + g.gPrice + "')"; return(DBHelper.GetLine(sql)); }
/// <summary> /// 物品详情 /// </summary> /// <returns></returns> public static System.Data.DataTable LoadGoodOnly(Entity.Goods g) { string sql = "select GName ,GCount ,GPrice from Goods where GID=" + g.gID + ""; return(DBHelper.GetDT(sql)); }