public async Task <ActionResult> Delete(string year, string month, string day, string locationname, string productcode) { MethodReturnResult result = new MethodReturnResult(); try { using (PlanDayServiceClient client = new PlanDayServiceClient()) { PlanDayKey key = new PlanDayKey() { Year = year, Month = month, Day = day, LocationName = locationname == null ? "" : locationname, ProductCode = productcode == null ? "" : productcode }; result = await client.DeleteAsync(key); if (result.Code == 0) { result.Message = string.Format(PPMResources.StringResource.PlanDay_Delete_Success, key); } else { //数据错误 result.Code = result.Code; //错误代码 result.Message = result.Message; //错误信息 result.Detail = result.Message; //错误明细 return(Json(result)); } return(Json(result)); } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }
public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize) { if (ModelState.IsValid) { int pageNo = currentPageNo ?? 0; int pageSize = currentPageSize ?? 20; if (Request["PageNo"] != null) { pageNo = Convert.ToInt32(Request["PageNo"]); } if (Request["PageSize"] != null) { pageSize = Convert.ToInt32(Request["PageSize"]); } using (PlanDayServiceClient client = new PlanDayServiceClient()) { await Task.Run(() => { PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <IList <PlanDay> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = result.Data; } }); } } return(PartialView("_ListPartial")); }
/// <summary> /// 查询 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <ActionResult> Query(PlanDayQueryViewModel model) { MethodReturnResult result = new MethodReturnResult(); try { using (PlanDayServiceClient client = new PlanDayServiceClient()) { //取得数据 await Task.Run(() => { //取数条件 StringBuilder where = new StringBuilder(); if (model != null) { //年度条件 if (!string.IsNullOrEmpty(model.qYear)) { where.AppendFormat(" {0} Key.Year = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.qYear); } //月度条件 if (!string.IsNullOrEmpty(model.qMonth)) { where.AppendFormat(" {0} Key.Month = '{1}'" , where.Length > 0 ? "and" : string.Empty , model.qMonth); } //车间条件 if (!string.IsNullOrEmpty(model.LocationName)) { where.AppendFormat(" {0} Key.LocationName = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.LocationName); } //产品条件 if (!string.IsNullOrEmpty(model.ProductCode)) { where.AppendFormat(" {0} Key.ProductCode = '{1}'" , where.Length > 0 ? "AND" : string.Empty , model.ProductCode); } } //设置参数 PagingConfig cfg = new PagingConfig() { OrderBy = "Key", Where = where.ToString() }; //取得数据 MethodReturnResult <IList <PlanDay> > resultlist = client.Get(ref cfg); if (resultlist.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = resultlist.Data; } else { //数据错误 result.Code = resultlist.Code; //错误代码 result.Message = resultlist.Message; //错误信息 result.Detail = resultlist.Message; //错误明细 } }); //处理错误信息 if (result.Code > 0) { return(Json(result)); //终止并返回程序 } } return(PartialView("_ListPartial")); } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }
/// <summary> /// 浏览信息 /// </summary> /// <param name="year">年</param> /// <param name="month">月</param> /// <param name="day">日</param> /// <param name="locationname">车间</param> /// <param name="productcode">产品</param> /// <returns></returns> public async Task <ActionResult> Detail(string year, string month, string day, string locationname, string productcode) { MethodReturnResult <PlanDay> result = new MethodReturnResult <PlanDay>(); try { PlanDayViewModel viewModel = new PlanDayViewModel(); using (PlanDayServiceClient client = new PlanDayServiceClient()) { PlanDayKey key = new PlanDayKey() { Year = year, Month = month, Day = day, LocationName = locationname == null ? "" : locationname, ProductCode = productcode == null ? "" : productcode }; //取得数据 result = await client.GetAsync(key); if (result.Code == 0) { viewModel = new PlanDayViewModel() { Year = result.Data.Key.Year, Month = result.Data.Key.Month, Day = result.Data.Key.Day, LocationName = result.Data.Key.LocationName, ProductCode = result.Data.Key.ProductCode, PlanQty = (int)float.Parse(result.Data.PlanQty), PlanWatt = result.Data.PlanWatt, PlanInQty = result.Data.PlanInQty, TargetDebrisRate = result.Data.TargetDebrisRate, PerCapitaEfficiency = result.Data.PerCapitaEfficiency, BeforePressQRate = result.Data.BeforePressQRate, HProductARate = result.Data.HProductARate, ProductARate = result.Data.ProductARate, CreateTime = result.Data.CreateTime, Creator = result.Data.Creator, Editor = result.Data.Editor, EditTime = result.Data.EditTime }; return(PartialView("_InfoPartial", viewModel)); } else { //数据错误 result.Code = result.Code; //错误代码 result.Message = result.Message; //错误信息 result.Detail = result.Message; //错误明细 return(Json(result)); } } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }
public async Task <ActionResult> SaveModify(PlanDayViewModel model) { MethodReturnResult result = new MethodReturnResult(); try { using (PlanDayServiceClient client = new PlanDayServiceClient()) { PlanDay obj = new PlanDay() { Key = new PlanDayKey() { Year = model.Year, Month = model.Month, Day = model.Day, LocationName = model.LocationName != null ? model.LocationName : "", ProductCode = model.ProductCode != null ? model.ProductCode : "" }, PlanQty = model.PlanQty.ToString(), PlanWatt = model.PlanWatt, PlanInQty = model.PlanInQty, TargetDebrisRate = model.TargetDebrisRate, PerCapitaEfficiency = model.PerCapitaEfficiency, BeforePressQRate = model.BeforePressQRate, HProductARate = model.HProductARate, ProductARate = model.ProductARate, Editor = User.Identity.Name, EditTime = DateTime.Now, CreateTime = model.CreateTime, Creator = model.Creator }; MethodReturnResult rst = await client.ModifyAsync(obj); if (rst.Code == 0) { rst.Message = string.Format(PPMResources.StringResource.PlanDay_Modify_Success, obj.Key); } else { //数据错误 result.Code = rst.Code; //错误代码 result.Message = rst.Message; //错误信息 result.Detail = rst.Message; //错误明细 return(Json(result)); } return(Json(rst)); } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); return(Json(result)); } }
// GET: /PPM/PlanDay/ /// <summary> /// 页面开始处理事物 /// </summary> /// <param name="year"> 年</param> /// <param name="month"> 月</param> /// <param name="locationname"> 车间</param> /// <returns></returns> public async Task <ActionResult> Index(string year, string month, string locationname) { MethodReturnResult result = new MethodReturnResult(); try { //初始化参数 string sYear = System.DateTime.Now.ToString("yyyy"); string sMonth = System.DateTime.Now.ToString("MM"); //获取日生产计划。 using (PlanDayServiceClient client = new PlanDayServiceClient()) { await Task.Run(() => { //设置查询条件 PagingConfig cfg = new PagingConfig() { IsPaging = false, Where = string.Format(@" Key.Year = '{0}' AND Key.Month = '{1}'", sYear, sMonth ) }; //取得列表数据 MethodReturnResult <IList <PlanDay> > resultlist = client.Get(ref cfg); if (resultlist.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.List = resultlist.Data; } else { //数据错误 result.Code = resultlist.Code; //错误代码 result.Message = resultlist.Message; //错误信息 result.Detail = resultlist.Message; //错误明细 } }); //处理错误信息 if (result.Code > 0) { return(Json(result)); //终止并返回程序 } } PlanDayQueryViewModel model = new PlanDayQueryViewModel { //初始化参数 qYear = sYear, //年 qMonth = sMonth, //月 }; return(View(model)); } catch (Exception ex) { result.Code = 1000; result.Message = ex.Message; result.Detail = ex.ToString(); return(Json(result)); } }
public async Task <ActionResult> Delete(string year, string month, string locationname) { MethodReturnResult result = new MethodReturnResult(); try { //判断是否存在日明细记录 using (PlanDayServiceClient client = new PlanDayServiceClient()) { StringBuilder where = new StringBuilder(); //年度条件 if (!string.IsNullOrEmpty(year)) { where.AppendFormat(" {0} Key.Year = '{1}'" , where.Length > 0 ? "AND" : string.Empty , year); } //月度条件 if (!string.IsNullOrEmpty(month)) { where.AppendFormat(" {0} Key.Month = '{1}'" , where.Length > 0 ? "and" : string.Empty , month); } //车间条件 if (!string.IsNullOrEmpty(locationname)) { where.AppendFormat(" {0} Key.LocationName = '{1}'" , where.Length > 0 ? "AND" : string.Empty , locationname); } //设置参数 PagingConfig cfg = new PagingConfig() { OrderBy = "Key", Where = where.ToString() }; //取得数据 MethodReturnResult <IList <PlanDay> > resultlist = client.Get(ref cfg); if (resultlist.Code == 0) { if (resultlist.Data.Count > 0) { //数据错误 result.Code = 1000; //错误代码 result.Message = "存在日计划"; //错误信息 return(Json(result)); } } else { //数据错误 result.Code = resultlist.Code; //错误代码 result.Message = resultlist.Message; //错误信息 result.Detail = resultlist.Message; //错误明细 return(Json(result)); } } using (PlanMonthServiceClient client = new PlanMonthServiceClient()) { PlanMonthKey key = new PlanMonthKey() { Year = year, Month = month, LocationName = locationname == null? "":locationname }; result = await client.DeleteAsync(key); if (result.Code == 0) { result.Message = string.Format(PPMResources.StringResource.PlanMonth_Delete_Success , key); } return(Json(result)); } } catch (Exception ex) { result.Code = 1000; result.Message = ex.Message; result.Detail = ex.ToString(); return(Json(result)); } }