public bool DeleteExt(Mes_Stock_InStockApproval obj)
{
////作废订单
//obj.OrderStatus = OrderStatus.ZF;
//this.CurDbSession.Update < Mes_Plan_SaleOrder>(obj);
return(true);
}
public List <Mes_Stock_InStockApproval> FindByPage(Mes_Stock_InStockApproval obj, ref PagerBase pager)
{
string sql = @"SELECT T1.* FROM Mes_Stock_InStockApproval T1 WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo ='{0}'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.BillType))
{
sql += string.Format(" AND T1.BillType ='{0}'", obj.BillType);
}
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_InStockApproval>());
}
public ActionResult InStockApproval_FindByPage(Mes_Stock_InStockApproval obj)
{
var list = MesStockInStockApprovalDao.Instance.FindByCond(obj);
int count = (list != null) ? list.Count : 0;
return(Json(new { total = count, rows = list }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 进货单审批
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult InStockMgt_Audit(Mes_Stock_InStockApproval obj)
{
if (obj.InStockID <= 0)
{
return(Json(new { IsSuccess = false, Message = "请先选择一个进货单！" }));
}
Mes_Stock_InStock dataObj = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(obj.InStockID);
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 = MesStockInStockDao.Instance.DoAudit(obj);
if (!string.IsNullOrEmpty(message))
{
return(Json(new { IsSuccess = false, Message = message }));
}
return(Json(new { IsSuccess = true, Message = "" }));
}
public List <Mes_Stock_InStockApproval> FindByCond(Mes_Stock_InStockApproval obj)
{
string sql = @"SELECT T1.* FROM Mes_Stock_InStockApproval T1 WITH(NOLOCK) WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo ='{0}'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.BillType))
{
sql += string.Format(" AND T1.BillType ='{0}'", obj.BillType);
}
sql += " ORDER BY CreatedTime DESC";
return(this.CurDbSession.FromSql(sql).ToList <Mes_Stock_InStockApproval>());
}
/// <summary>
/// 审批进货单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public string DoAudit(Mes_Stock_InStockApproval obj)
{
//1.先校验当前的审核人是否为配置对象，并且没有审核过
string sql = @"SELECT TOP 1 ID FROM dbo.Mes_Sys_FlowConfig WITH(NOLOCK) WHERE BusinessType = '{0}' AND OptUserID = {1}";
sql = string.Format(sql, FlowBusinessType.A, obj.ApproverID);
int result = this.CurDbSession.FromSql(sql).ToScalar <int>();
if (result <= 0)
{
return(string.Format("流程中未配置【{0}】对进货单进行审批！", obj.ApproverName));
}
sql = @"SELECT TOP 1 ID FROM Mes_Stock_InStockApproval WITH(NOLOCK) WHERE BillNo = '{0}' AND BillType='{1}'
AND ApproverID = {2}";
sql = string.Format(sql, obj.BillNo, obj.BillType, obj.ApproverID);
result = this.CurDbSession.FromSql(sql).ToScalar <int>();
if (result > 0)
{
return(string.Format("【{0}】已经审批过了，不允许重复审批！", obj.ApproverName));
}
//2.保存审批记录
this.CurDbSession.Insert(obj);
//3.检测是否所有人已审批完，并修改状态
sql = @"SELECT TOP 1 ID FROM dbo.Mes_Sys_FlowConfig WITH(NOLOCK) WHERE BusinessType = '{0}'
AND OptUserID NOT IN (
SELECT ApproverID FROM Mes_Stock_InStockApproval WITH(NOLOCK) WHERE BillNo = '{1}' AND BillType='{2}'
)";
sql = string.Format(sql, FlowBusinessType.A, obj.BillNo, obj.BillType);
result = this.CurDbSession.FromSql(sql).ToScalar <int>();
if (result <= 0) //表示所有人都已审批，可以修改进货单状态为【已审批】
{
sql = string.Format("UPDATE Mes_Stock_InStock SET AuditStatus = {0} WHERE ID = {1}", obj.InStockID, AuditEnum.Yes);
result = this.CurDbSession.FromSql(sql).ExecuteNonQuery();
}
return(string.Empty);
}
