public HttpResponseBase ScheduleParamerAll()
{
string json = string.Empty;
ScheduleParamer sp = new ScheduleParamer();
try
{
//if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))//判斷id是不是存在.也就是說是否選擇了運送方式.當id不為0時表示選擇了運送方式.
//{
// sp.schedule_code = Request.Params["schedule_code"];
//}
sp.schedule_code = Request.Params["code"];
_schmerMgr = new ScheduleParamerMgr(mySqlConnectionString);
DataTable _dt = _schmerMgr.GetScheduleParamerList(sp.schedule_code);
//根據行para_value和行para_name拼接成一個json
int lenght = _dt.Rows.Count;
json = "{";
for (int i = 1; i <= _dt.Rows.Count; i++)
{
json = json + "\"" + _dt.Rows[i - 1]["para_name"] + "\":\"" + _dt.Rows[i - 1]["para_value"] + "\"";
if (lenght == i)
{
continue;
}
else
{
json = json + ",";
}
}
if (lenght > 0)
{
json = json + "}";
}
else
{
json = "{\"msg\":\"無數據信息\"}";
}
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase ScheduleParamerList()
{
string json = string.Empty;
ScheduleParamer sp = new ScheduleParamer();
List<ScheduleParamer> spList = new List<ScheduleParamer>();
int totalCount = 0;
try
{
_schmerMgr = new ScheduleParamerMgr(mySqlConnectionString);
sp.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
sp.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
spList = _schmerMgr.GetScheduleParameterList(sp, out totalCount);
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(spList, Formatting.Indented) + "}";//返回json數據
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public JsonResult UpdateActive()
{
ScheduleParamer sp = new ScheduleParamer();
try
{
_schmerMgr = new ScheduleParamerMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
sp.para_id = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
sp.para_status = Convert.ToInt32(Request.Params["active"].ToString());
}
if (sp.para_id != 0)
{
int res = _schmerMgr.UpdateActive(sp);
if (res > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
else
{
return Json(new { success = "false" });
}
}
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 HttpResponseBase DeleteScheduleParameter()
{
string json = string.Empty;
ScheduleParamer sp = new ScheduleParamer();
try
{
_schmerMgr = new ScheduleParamerMgr(mySqlConnectionString);
string id = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["rowID"]))
{
id = Request.Params["rowID"].ToString();
}
string[] ids = id.Split('|');
for (int i = 0; i < ids.Length - 1; i++)
{
sp.para_id = Convert.ToInt32(ids[i]);
if (sp.para_id > 0)
{
int delresult = _schmerMgr.DelScheduleParamer(sp);
if (delresult <= 0)
{
json = "{success:true,msg:'" + i + 1 + "'}";
break;
}
}
else
{
json = "{success:false}";
break;
}
}
json = "{success:true,msg:''}";//返回json數據
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase ScheduleParamerSave()
{
string json = string.Empty;
ScheduleParamer sp = new ScheduleParamer();
try
{
_schmerMgr = new ScheduleParamerMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["para_id"]))
{
sp.para_id = Convert.ToInt32(Request.Params["para_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["para_value"]))
{
sp.para_value = Request.Params["para_value"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["para_name"]))
{
sp.para_name = Request.Params["para_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))
{
sp.schedule_code = Request.Params["schedule_code"].ToString();
}
sp.para_status = 1;
if (sp.para_id != 0)
{
int res = _schmerMgr.UpdateScheduleParamer(sp);
if (res > 0)
{
json = "{success:true}";//返回json數據
}
else
{
json = "{success:false}";//返回json數據
}
}
else
{
int res = _schmerMgr.InsertScheduleParamer(sp);
if (res > 0)
{
json = "{success:true}";//返回json數據
}
else
{
json = "{success:false}";//返回json數據
}
}
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}