public bool DeleteItemExt(Mes_Stock_ProductInStockItem obj)
{
string sql = string.Format("DELETE FROM Mes_Stock_ProductInStockItem WHERE ID={0}", obj.ID);
this.CurDbSession.FromSql(sql).ExecuteNonQuery();
return(true);
}
public ActionResult ProductInStockItemMgt_FindByPage(Mes_Stock_ProductInStockItem obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = StockProductInStockDao.Instance.FindItemByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult ProductInStockItemMgt_Save(Mes_Stock_ProductInStockItem obj)
{
if (obj.ProductInStockID <= 0)
{
return(Json(new { IsSuccess = false, Message = "请先选择一个入库单进行操作！" }));
}
if (string.IsNullOrEmpty(obj.MaterialProNo))
{
return(Json(new { IsSuccess = false, Message = "【物料编码】不能为空！" }));
}
Mes_Stock_ProductInStock main = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStock, int>(obj.ProductInStockID.Value);
if (main == null)
{
return(Json(new { IsSuccess = false, Message = "选择的入库单信息有误！" }));
}
Mes_Stock_ProductInStockItem itemObj = null;
if (obj.ID > 0)
{
itemObj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStockItem, int>(obj.ID);
}
else
{
itemObj = new Mes_Stock_ProductInStockItem();
//生成订单行号
itemObj.ResNum = StockProductInStockDao.Instance.GenResNum(main);
}
if (itemObj == null)
{
return(Json(new { IsSuccess = false, Message = "入库单明细信息有误，请刷新后重试！" }));
}
itemObj.ProductInStockID = obj.ProductInStockID;
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.Num = obj.Num;
itemObj.WorkOrderType = obj.WorkOrderType;
itemObj.WorkOrderNumber = obj.WorkOrderNumber;
itemObj.Memo = obj.Memo;
itemObj.StockID = obj.StockID;
itemObj.AlibraryID = obj.AlibraryID;
int id = StockProductInStockDao.Instance.Save <Mes_Stock_ProductInStockItem>(itemObj);
return(Json(new { IsSuccess = true, Message = id.ToString() }));
}
public ActionResult ProductInStockItemMgt_Delete(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Stock_ProductInStockItem obj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStockItem, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "入库单明细不存在，请刷新后重试！" }));
}
StockProductInStockDao.Instance.DeleteItemExt(obj);
return(Json(new { IsSuccess = true, Message = "" }));
}
public List <Mes_Stock_ProductInStockItem> FindItemByPage(Mes_Stock_ProductInStockItem obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.StockName FROM Mes_Stock_ProductInStockItem T1 WITH(NOLOCK)
LEFT JOIN dbo.Mes_Sys_Stock T2 WITH(NOLOCK) ON T1.StockID = T2.ID
WHERE 1=1 AND T1.ProductInStockID = {0}";
sql = string.Format(sql, obj.ProductInStockID);
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_ProductInStockItem>());
}
