/// <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 GetItemInfo()
{
try
{
int scheduleid = Request["scheduleid"] == null ? 0 : int.Parse(Request["scheduleid"]);//key的值
_scheduleItemMgr = new ScheduleItemMgr(connectionString);
List<ScheduleItemCustom> list = _scheduleItemMgr.Query(new ScheduleItem { schedule_Id = scheduleid });
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 DeleteItem()
{
try
{
string item_type = Request["item_type"] == null ? "0" : Request["item_type"];
string item_value = Request["item_value"] == null ? "0" : Request["item_value"];
string rowIds = Request["rowID"];
rowIds =rowIds.Remove(rowIds.Length-1, 1);
string schedule_id = Request["schedule_id"];
_scheduleItemMgr = new ScheduleItemMgr(connectionString);
return Json(_scheduleItemMgr.Delete(Convert.ToInt32(schedule_id),rowIds,item_type,item_value));
}
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 SaveItem()
{
try
{
string scheduleStr = Request["relevants"];
List<ScheduleItem> lists = JsonConvert.DeserializeObject<List<ScheduleItem>>(scheduleStr);
_scheduleItemMgr = new ScheduleItemMgr(connectionString);
return Json(_scheduleItemMgr.UpdateByBacth(lists));
}
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 });
}
}
