/// <summary> /// 查詢排程 /// </summary> /// <param name="sc"></param> /// <returns></returns> public ActionResult GetTiers(ScheduleQuery sc) { try { int vendor_id = Request["vendorId"] == null ? 0:int.Parse(Request["vendorId"]); string product_id = Request["product_id"] == null ? "" : Request["product_id"]; List<Schedule> list = new List<Schedule>(); _fstMgr = new ScheduleMgr(connectionString); list = _fstMgr.Query(sc); IsoDateTimeConverter iso = new IsoDateTimeConverter() { DateTimeFormat = "yyyy/MM/dd" }; return Content(JsonConvert.SerializeObject(list, Formatting.None, iso)); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); return new EmptyResult(); } }
public ActionResult GetTiersByConditon(ScheduleQuery sc) { try { string vendor_id = Request["vendorId"] == null ? "0" : Request["vendorId"]; string product_id = Request["product_id"] == null ? "" : Request["product_id"]; IScheduleItemImplMgr _scheduleItemMgr = new ScheduleItemMgr(connectionString); List<ScheduleItemCustom> list = _scheduleItemMgr.QueryByCondition(new ScheduleItem { type = 1 }); List<ScheduleItemCustom> resultList = new List<ScheduleItemCustom>(); if (product_id != "") { ///eidt by wwei0216w 2018/9/27 添加對schedule_name的判斷,防止錯誤數據造成 排程選中時的空白選項 list = list.FindAll(m => m.key1 == 1&& m.schedule_name!=""); if (list.Count > 0) { list = list.FindAll(m => m.value1 == vendor_id); } } resultList.AddRange(list); IsoDateTimeConverter iso = new IsoDateTimeConverter() { DateTimeFormat = "yyyy/MM/dd" }; return Content(JsonConvert.SerializeObject(resultList, Formatting.None, iso)); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); return new EmptyResult(); } }