public HttpResponseBase GetPacket()
{
string json = string.Empty;
List<AreaPacket> store = new List<AreaPacket>();
try
{
_areaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["ele_type"]))
{
store = _areaPacketMgr.GetPacket(int.Parse(Request.Params["ele_type"].ToString()));
}
else
{
store = _areaPacketMgr.GetPacket(0);
}
json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}";
}
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,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public JsonResult UpdateAreaPacketActive()
{
string jsonStr = string.Empty;
try
{
_areaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
int id = Convert.ToInt32(Request.Params["id"]);
AreaPacket model = new AreaPacket();
model.packet_id = id;
model = _areaPacketMgr.GetModelById(model);
int statusValue = Convert.ToInt32(Request.Params["active"]);
model.packet_id = id;
model.packet_status = statusValue;
model.update_userid = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
model.packet_updatedate = DateTime.Now;
if (_areaPacketMgr.UpAreaPacketStatus(model) > 0)
{
return Json(new { success = "true" });
}
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" });
}
}
/// <summary>
/// 根據信息包的id獲取其element_type
/// </summary>
/// <returns></returns>
public HttpResponseBase GetElementTypeInPacket()
{
string json = string.Empty;
int isTryInt = 0;
int totalCount = 0;
try
{
if (!string.IsNullOrEmpty(Request.Params["PacketId"].ToString()))
{
if (int.TryParse(Request.Params["PacketId"].ToString(), out isTryInt))
{
_areaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
AreaPacket store = _areaPacketMgr.QueryAll(new AreaPacket { packet_id = Convert.ToInt32(Request.Params["PacketId"].ToString()) }, out totalCount).FirstOrDefault();
json = "{success:true,elementType:" + store.element_type + "}";
}
else
{
json = "{success:false,elementType:-1}";
}
}
else
{
json = "{success:false,elementType:-1}";
}
}
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;
}
/// <summary>
/// 區域包列表
/// </summary>
/// <returns></returns>
public HttpResponseBase AreaPacketList()
{
List<AreaPacket> stores = new List<AreaPacket>();
string json = string.Empty;
try
{
AreaPacket query = new AreaPacket();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Params["serchcontent"]))
{
query.packet_name = Request.Params["serchcontent"].ToString();
query.packet_desc = Request.Params["serchcontent"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["serchtype"]))
{
query.element_type = Convert.ToInt32(Request.Params["serchtype"].ToString());
}
_areaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
int totalCount = 0;
stores = _areaPacketMgr.QueryAll(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";
//返回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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetId()
{
string json = string.Empty;
//if (!string.IsNullOrEmpty(Request.Params["PacketId"]))
//{
_areaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
int packtId = Convert.ToInt32(Request.Params["PacketId"].ToString());
try
{
if (_areaPacketMgr.SelectCount(packtId))
{
json = "{success:true}";
}
else
{
json = "{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);
json = "{success:false}";
}
// }
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
