public JsonResult DoAudit(int Id) { try { StockInType obj = GetById(Id); obj.IsAudit = 1; NSession.SaveOrUpdate(obj); NSession.Flush(); IList <WarehouseStockType> list = NSession.CreateQuery(" from WarehouseStockType where WId=:p1 and SKU=:p2").SetInt32("p1", obj.WId).SetString("p2", obj.SKU).List <WarehouseStockType>(); if (list.Count > 0) { WarehouseStockType ws = list[0]; ws.Qty = ws.Qty + obj.Qty; NSession.SaveOrUpdate(ws); NSession.Flush(); Utilities.SetComposeStock(obj.SKU, NSession); Utilities.CreateSKUCode(obj.SKU, obj.Qty, obj.Id.ToString(), NSession); IList <OrderType> orders = NSession.CreateQuery(" from OrderType where Id in(select OId from OrderProductType where SKU ='" + obj.SKU + "' and IsQue=1) and IsOutOfStock=1").List <OrderType>(); foreach (OrderType item in orders) { OrderHelper.SetQueOrder(item, NSession); } } } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public JsonResult Create(StockInType obj) { try { IList <WarehouseStockType> list = NSession.CreateQuery(" from WarehouseStockType where WId=:p1 and SKU=:p2").SetInt32("p1", obj.WId). SetString("p2", obj.SKU).List <WarehouseStockType>(); if (list.Count > 0) { obj.IsAudit = 0; obj.CreateBy = CurrentUser.Realname; obj.CreateOn = DateTime.Now; NSession.SaveOrUpdate(obj); NSession.Flush(); } else { return(Json(new { IsSuccess = false, ErrorMsg = "该产品没有在系统中。请先添加产品!" })); } } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult Edit(int id) { StockInType obj = GetById(id); ViewData["sku"] = obj.SKU; return(View(obj)); }
public ActionResult Edit(StockInType obj) { try { NSession.Update(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
/// <summary> /// 根据Id获取 /// </summary> /// <param name="Id"></param> /// <returns></returns> public StockInType GetById(int Id) { StockInType obj = NSession.Get <StockInType>(Id); if (obj == null) { throw new Exception("返回实体为空"); } else { return(obj); } }
public static bool StockIn(int wid, string sku, int num, double price, string InType, string user, string memo, ISession NSession, bool isAudit = false) { IList <WarehouseStockType> list = NSession.CreateQuery(" from WarehouseStockType where WId=:p1 and SKU=:p2").SetInt32("p1", wid).SetString("p2", sku).List <WarehouseStockType>(); if (list.Count > 0) { WarehouseStockType ws = list[0]; ws.Qty = ws.Qty + num; ws.UpdateOn = DateTime.Now; NSession.SaveOrUpdate(ws); NSession.Flush(); SetComposeStock(sku, NSession); StockInType stockInType = new StockInType(); stockInType.IsAudit = 0; if (isAudit) { stockInType.IsAudit = 1; } stockInType.Price = price; stockInType.Qty = num; stockInType.SKU = sku; stockInType.WId = wid; stockInType.InType = InType; stockInType.Memo = memo; stockInType.WName = ws.Warehouse; stockInType.SourceQty = ws.Qty - num; stockInType.CreateBy = user; stockInType.CreateOn = DateTime.Now; NSession.SaveOrUpdate(stockInType); NSession.Flush(); if (price > 0) { NSession.CreateSQLQuery(" update Products set Price=" + price + " where SKU='" + sku + "'") .UniqueResult(); NSession.Flush(); } IList <OrderType> orders = NSession.CreateQuery(" from OrderType where Id in(select OId from OrderProductType where SKU ='" + sku + "' and IsQue=1) and IsOutOfStock=1").List <OrderType>(); foreach (OrderType item in orders) { OrderHelper.SetQueOrder(item, NSession); } return(true); } return(false); }
public JsonResult DeleteConfirmed(int id) { try { StockInType obj = GetById(id); NSession.Delete("from SKUCodeType where PlanNo='" + obj.Id + "'"); NSession.Flush(); Utilities.StockOut(1, obj.SKU, obj.Qty, "入库删除", CurrentUser.Realname, "", "", NSession); NSession.Delete(obj); NSession.Flush(); } catch (Exception ee) { return(Json(new { IsSuccess = false, ErrorMsg = "出错了" })); } return(Json(new { IsSuccess = true })); }
public ActionResult PrintSKU(int Id) { StockInType obj = NSession.Get <StockInType>(Id); if (obj != null) { NSession.Flush(); IList <SKUCodeType> list = NSession.CreateQuery("from SKUCodeType where PlanNo='" + obj.Id + "'"). List <SKUCodeType>(); DataTable dt = new DataTable(); dt.Columns.Add("sku"); dt.Columns.Add("name"); dt.Columns.Add("num"); dt.Columns.Add("date"); dt.Columns.Add("people"); dt.Columns.Add("desc"); dt.Columns.Add("code"); int i = 1; foreach (SKUCodeType skuCodeType in list) { DataRow dr = dt.NewRow(); dr[0] = obj.SKU; dr[1] = obj.SKU; dr[2] = i + "/" + obj.Qty; dr[3] = obj.CreateOn; dr[4] = obj.CreateBy; dr[5] = "手动入库"; dr[6] = skuCodeType.Code; dt.Rows.Add(dr); i++; } DataSet ds = new DataSet(); ds.Tables.Add(dt); PrintDataType data = new PrintDataType(); data.Content = ds.GetXml(); data.CreateOn = DateTime.Now; NSession.Save(data); NSession.Flush(); return(Json(new { IsSuccess = true, Result = data.Id })); } return(Json(new { IsSuccess = false })); }