public bool DeleteItemExt(Mes_Stock_InStockItem obj) { string sql = string.Format("DELETE FROM Mes_Stock_InStockItem WHERE ID={0}", obj.ID); this.CurDbSession.FromSql(sql).ExecuteNonQuery(); return(true); }
public ActionResult InStockItemMgt_Save(Mes_Stock_InStockItem obj) { if (obj.InStockID <= 0) { return(Json(new { IsSuccess = false, Message = "请先选择一个进货单进行操作!" })); } if (string.IsNullOrEmpty(obj.MaterialProNo)) { return(Json(new { IsSuccess = false, Message = "【物料编码】不能为空!" })); } Mes_Stock_InStock main = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(obj.InStockID.Value); if (main == null) { return(Json(new { IsSuccess = false, Message = "选择的进货单信息有误!" })); } Mes_Stock_InStockItem itemObj = null; if (obj.ID > 0) { itemObj = MesStockInStockDao.Instance.Find <Mes_Stock_InStockItem, int>(obj.ID); itemObj.CheckItemStatus = obj.CheckItemStatus; } else { itemObj = new Mes_Stock_InStockItem(); itemObj.AcceptNum = 0; itemObj.BackNum = 0; itemObj.AcceptStatus = YesNoType.No; itemObj.CheckItemStatus = CheckStatus.No; //生成订单行号 itemObj.ResNum = MesStockInStockDao.Instance.GenResNum(main); } if (itemObj == null) { return(Json(new { IsSuccess = false, Message = "进货单明细信息有误,请刷新后重试!" })); } itemObj.InStockID = obj.InStockID; itemObj.BillType = main.BillType; itemObj.BillNo = main.BillNo; itemObj.MaterialProNo = obj.MaterialProNo; itemObj.MaterialCode = obj.MaterialCode; itemObj.Version = obj.Version; itemObj.MaterialSize = obj.MaterialSize; itemObj.Unit = obj.Unit; itemObj.BatchNo = obj.BatchNo; itemObj.AcceptNum = obj.AcceptNum; itemObj.InStockNum = obj.InStockNum; itemObj.AcceptDate = obj.AcceptDate; itemObj.BackNum = obj.BackNum; itemObj.StockID = obj.StockID; int id = MesStockInStockDao.Instance.Save <Mes_Stock_InStockItem>(itemObj); return(Json(new { IsSuccess = true, Message = id.ToString() })); }
public ActionResult InStockItemMgt_FindByPage(Mes_Stock_InStockItem obj, int page, int rows) { var pager = new PagerBase() { CurrentPageIndex = page, PageSize = rows }; var list = MesStockInStockDao.Instance.FindItemByPage(obj, ref pager); return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet)); }
public ActionResult InStockItemMgt_Delete(int ID) { if (ID <= 0) { return(Json(new { IsSuccess = false, Message = "选择的记录有误,请刷新后重试!" })); } Mes_Stock_InStockItem obj = MesStockInStockDao.Instance.Find <Mes_Stock_InStockItem, int>(ID); if (obj == null) { return(Json(new { IsSuccess = false, Message = "进货单明细不存在,请刷新后重试!" })); } MesStockInStockDao.Instance.DeleteItemExt(obj); return(Json(new { IsSuccess = true, Message = "" })); }
public List <Mes_Stock_InStockItem> FindItemByPage(Mes_Stock_InStockItem obj, ref PagerBase pager) { string sql = @"SELECT T1.*,T2.StockName FROM Mes_Stock_InStockItem T1 WITH(NOLOCK) LEFT JOIN dbo.Mes_Sys_Stock T2 WITH(NOLOCK) ON T1.StockID = T2.ID WHERE 1=1 AND T1.InStockID = {0}"; sql = string.Format(sql, obj.InStockID); string orderBy = pager.OrderBy; if (string.IsNullOrEmpty(orderBy)) { orderBy = "ResNum ASC"; } string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo); string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal))); //查询总记录数 pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>(); //返回当前页的记录数 return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Stock_InStockItem>()); }