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 = "" })); }