/// <summary> /// 保存數據 /// </summary> /// <param name="fst"></param> /// <returns></returns> public ActionResult TierSetSave(Schedule fst) { try { _fstMgr = new ScheduleMgr(connectionString); fst.create_user = (Session["caller"] as Caller).user_id; fst.create_date = DateTime.Now; bool result = _fstMgr.Save(fst); return Json(new { success = result }); } 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 View(); }
/// <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(); } }
/// <summary> /// 加載類型relevantStore /// </summary> public ActionResult relevantStore() { try { int scheduleid = Request["schedule_id"] == null ? 0 : int.Parse(Request["schedule_id"]);//key的值 string xmlPath = Server.MapPath("../XML/ParameterSrc.xml"); _scheduleItemMgr = new ScheduleItemMgr(connectionString); List<ScheduleItemCustom> list = _scheduleItemMgr.Query(new ScheduleItem { schedule_Id=scheduleid}); _fstMgr = new ScheduleMgr(connectionString); List<Parametersrc> typeList = _fstMgr.GetRelevantInfo(xmlPath, "ScheduleType"); List<Parametersrc> keyList = _fstMgr.GetRelevantInfo(xmlPath, "Schedule_Key"); foreach (ScheduleItemCustom i in list) { i.keyStr = keyList.Find(m=>m.ParameterCode==i.key1.ToString()).parameterName; i.tabType = typeList.Find(m=>m.ParameterCode==i.type.ToString()).parameterName; } return Json(list); } 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 Json(new { success = false }); } }
public ActionResult GetValueInfo() { try { int keyType =Request["keyType"]==null ? 0: int.Parse(Request["keyType"]);//key的值 keyType = 1; _fstMgr = new ScheduleMgr(connectionString); return Json(_fstMgr.GetValue(keyType)); } 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 Json(new { success = false }); } }
public ActionResult GetRelevantType() { try { string type = Request["type"]; string xmlPath = Server.MapPath("../XML/ParameterSrc.xml"); _fstMgr = new ScheduleMgr(connectionString); return Json(_fstMgr.GetRelevantInfo(xmlPath, type)); } 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 Json(new { success = false }); } }
public ActionResult DeleteTires(string rowID) { try { int[] ids = (from i in rowID.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries) select int.Parse(i)).ToArray(); _fstMgr = new ScheduleMgr(connectionString); _fstMgr.Delete(ids); return Json(new { success = true }); } 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 Json(new { success = false }); } }