public ActionResult PlanMgt_FindByPage(Mes_Plan_PlanInfor obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesPlanPlanInforDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult PlanMgt_Find(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Plan_PlanInfor obj = MesPlanPlanInforDao.Instance.Find <Mes_Plan_PlanInfor, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "计划信息不存在，请刷新后重试！" }));
}
return(Json(new { IsSuccess = true, Message = JsonHelper.SerializeObject(obj) }, JsonRequestBehavior.AllowGet));
}
public ActionResult PlanMgt_Save(Mes_Plan_PlanInfor obj)
{
if (string.IsNullOrEmpty(obj.OrderType) || string.IsNullOrEmpty(obj.OrderNo))
{
return(Json(new { IsSuccess = false, Message = "请选择计划对应的工单！" }));
}
if (string.IsNullOrEmpty(obj.MaterialProNo) || string.IsNullOrEmpty(obj.Version))
{
return(Json(new { IsSuccess = false, Message = "工单对应的产品信息不能为空！" }));
}
Mes_Plan_PlanInfor plan = null;
if (obj.ID > 0)
{
plan = MesPlanPlanInforDao.Instance.Find <Mes_Plan_PlanInfor, int>(obj.ID);
}
else
{
plan = new Mes_Plan_PlanInfor();
plan.PlanStatus = PlanStatus.A;
plan.Creater = base.CurUser.UserId;
plan.CreatedTime = DateTime.Now;
//生成计划批号
plan.PlanCode = MesPlanPlanInforDao.Instance.GenPlanNo();
}
if (plan == null)
{
return(Json(new { IsSuccess = false, Message = "计划信息有误，请刷新后重试！" }));
}
plan.PlanType = obj.PlanType;
plan.OrderType = obj.OrderType;
plan.OrderNo = obj.OrderNo;
plan.MaterialProNo = obj.MaterialProNo;
plan.MaterialCode = obj.MaterialCode;
plan.Version = obj.Version;
plan.PlanNum = obj.PlanNum;
plan.CompleteNum = obj.CompleteNum;
plan.Unit = obj.Unit;
plan.WorkShopID = obj.WorkShopID;
plan.BeginTime = obj.BeginTime;
plan.EndTime = obj.EndTime;
plan.Factory = obj.Factory;
int id = MesPlanPlanInforDao.Instance.Save(plan);
return(Json(new { IsSuccess = true, Message = id.ToString() }));
}
public List <Mes_Plan_PlanInfor> FindByPage(Mes_Plan_PlanInfor obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.WorkShopName FROM Mes_Plan_PlanInfor T1
LEFT JOIN dbo.Mes_Sys_WorkShop T2 ON T1.WorkShopID = T2.ID
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.OrderType) > 0)
{
sql += string.Format(" AND T1.OrderType = '{0}'", obj.OrderType);
}
if (!string.IsNullOrEmpty(obj.OrderNo))
{
sql += string.Format(" AND T1.OrderNo LIKE '%{0}%'", obj.OrderNo);
}
if (!string.IsNullOrEmpty(obj.PlanCode))
{
sql += string.Format(" AND T1.PlanCode LIKE '%{0}%'", obj.PlanCode);
}
if (obj.PlanStatus > 0)
{
sql += string.Format(" AND T1.PlanStatus = {0}", obj.PlanStatus);
}
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_Plan_PlanInfor>());
}
/// <summary>
/// 删除订单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public ActionResult PlanMgt_Delete(int ID)
{
if (ID <= 0)
{
return(Json(new { IsSuccess = false, Message = "选择的记录有误，请刷新后重试！" }));
}
Mes_Plan_PlanInfor obj = MesPlanPlanInforDao.Instance.Find <Mes_Plan_PlanInfor, int>(ID);
if (obj == null)
{
return(Json(new { IsSuccess = false, Message = "计划信息不存在，请刷新后重试！" }));
}
if (obj.PlanStatus != PlanStatus.A)
{
return(Json(new { IsSuccess = false, Message = "计划已在流程中，不允许作废！" }));
}
MesPlanPlanInforDao.Instance.Delete(obj);
return(Json(new { IsSuccess = true, Message = "" }));
}
