public ActionResult ProductInStockMgt_Save(Mes_Stock_ProductInStock obj)
{
if (string.IsNullOrEmpty(obj.BillType))
{
return(Json(new { IsSuccess = false, Message = "请选择入库单单别！" }));
}
Mes_Stock_ProductInStock dataObj = null;
if (obj.ID > 0)
{
dataObj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStock, int>(obj.ID);
}
else
{
dataObj = new Mes_Stock_ProductInStock();
dataObj.AuditStatus = AuditEnum.No;
dataObj.Creater = base.CurUser.UserId;
dataObj.CreatedTime = DateTime.Now;
//生成单号
dataObj.BillNo = StockProductInStockDao.Instance.GenBillNo();
}
if (dataObj == null)
{
return(Json(new { IsSuccess = false, Message = "入库单信息有误，请刷新后重试！" }));
}
dataObj.BillType = obj.BillType;
dataObj.InStockDate = obj.InStockDate;
dataObj.BillDate = obj.BillDate;
dataObj.TotalNum = obj.TotalNum;
dataObj.Factory = obj.Factory;
dataObj.Memo = obj.Memo;
int id = StockProductInStockDao.Instance.Save(dataObj);
return(Json(new { IsSuccess = true, Message = id.ToString() }));
}
/// <summary>
/// 入库单审批
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult ProductInStockMgt_Audit(Mes_Stock_ProductInStock obj)
{
if (obj.ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "请先选择一个入库单！" }));
}
Mes_Stock_ProductInStock dataObj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStock, int>(obj.ID);
if (dataObj == null)
{
return(Json(new { IsSuccess = false, Message = "选择的入库单不存在，请刷新后重试！" }));
}
if (dataObj.AuditStatus == AuditEnum.Yes)
{
return(Json(new { IsSuccess = false, Message = "选择的入库单已审批，不允许重复审批！" }));
}
//obj.ApproverID = base.CurUser.ID;
//obj.ApproverName = base.CurUser.UserName;
//obj.BillNo = dataObj.BillNo;
//obj.BillType = dataObj.BillType;
//obj.Creater = base.CurUser.UserId;
//obj.CreatedTime = DateTime.Now;
//string message = StockProductInStockDao.Instance.DoAudit(obj);
//if (!string.IsNullOrEmpty(message))
//{
// return Json(new { IsSuccess = false, Message = message });
//}
return(Json(new { IsSuccess = true, Message = "" }));
}
/// <summary>
/// 生成行号
/// </summary>
/// <returns></returns>
public int GenResNum(Mes_Stock_ProductInStock obj)
{
string sql = "SELECT ISNULL(MAX(ResNum),0) FROM Mes_Stock_ProductInStockItem T1 WITH(NOLOCK) WHERE ProductInStockID = {0}";
sql = string.Format(sql, obj.ID);
int resNo = this.CurDbSession.FromSql(sql).ToScalar <int>();
return(resNo + 1);
}
public ActionResult ProductInStockMgt_FindByPage(Mes_Stock_ProductInStock obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = StockProductInStockDao.Instance.FindByPage(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 List <Mes_Stock_ProductInStock> FindByPage(Mes_Stock_ProductInStock obj, ref PagerBase pager)
{
string sql = @"SELECT T1.* FROM Mes_Stock_ProductInStock T1 WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
{
sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
}
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.InStockDateStart))
{
sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
}
if (!string.IsNullOrEmpty(obj.InStockDateEnd))
{
sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
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_ProductInStock>());
}
public ActionResult ProductInStockMgt_Find(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Stock_ProductInStock obj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStock, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "信息不存在，请刷新后重试！" }));
}
return(Json(new { IsSuccess = true, Message = JsonHelper.SerializeObject(obj) }, JsonRequestBehavior.AllowGet));
}
public List <Mes_Stock_ProductInStock> FindByCond(Mes_Stock_ProductInStock obj)
{
string sql = @"SELECT T1.* FROM Mes_Stock_ProductInStock T1 WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
{
sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
}
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.InStockDateStart))
{
sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
}
if (!string.IsNullOrEmpty(obj.InStockDateEnd))
{
sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
sql += " ORDER BY CreatedTime DESC";
//返回当前页的记录数
return(this.CurDbSession.FromSql(sql).ToList <Mes_Stock_ProductInStock>());
}
public ActionResult ProductInStockMgt_Delete(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Stock_ProductInStock obj = StockProductInStockDao.Instance.Find <Mes_Stock_ProductInStock, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "入库单不存在，请刷新后重试！" }));
}
if (obj.AuditStatus != AuditEnum.No)
{
return(Json(new { IsSuccess = false, Message = "只能删除未审核的入库单！" }));
}
StockProductInStockDao.Instance.DeleteExt(ID);
return(Json(new { IsSuccess = true, Message = "" }));
}
