public HttpResponseBase DeleteEdmPageMeta()
{
string json = "{success:false}";
try
{
string rowID = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["rowID"]))
{
rowID = Request.Params["rowID"];
_pageMetaMgr = new PageMetaDataMgr(mySqlConnectionString);
if (_pageMetaMgr.DeletePageMeta(rowID) > 0)
{
json = "{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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetPageMetaList()
{
string json = string.Empty;
try
{
PageMetaData query = new PageMetaData();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Params["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
else
{
query.Limit = 25;
}
if (!string.IsNullOrEmpty(Request.Params["search_content"]))
{
query.pm_page_name = Request.Params["search_content"].ToString();
query.pm_title = query.pm_page_name;
query.pm_keywords = query.pm_page_name;
}
int totalCount = 0;
_pageMetaMgr = new PageMetaDataMgr(mySqlConnectionString);
List<PageMetaData> stores = _pageMetaMgr.GetPageMetaDataList(query, ref totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
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:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SavePageMeta()
{
string json = "{success:false}";
try
{
PageMetaData query = new PageMetaData();
if (!string.IsNullOrEmpty(Request.Params["pm_id"]))
{
query.pm_id = Convert.ToInt32(Request.Params["pm_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["pm_page_name"]))
{
query.pm_page_name = Request.Params["pm_page_name"];
}
if (!string.IsNullOrEmpty(Request.Params["pm_title"]))
{
query.pm_title = Request.Params["pm_title"];
}
if (!string.IsNullOrEmpty(Request.Params["pm_url_para"]))
{
query.pm_url_para = Request.Params["pm_url_para"];
}
if (!string.IsNullOrEmpty(Request.Params["pm_keywords"]))
{
query.pm_keywords = Request.Params["pm_keywords"];
}
if (!string.IsNullOrEmpty(Request.Params["pm_description"]))
{
query.pm_description = Request.Params["pm_description"];
}
_pageMetaMgr = new PageMetaDataMgr(mySqlConnectionString);
if (query.pm_id == 0)
{
query.pm_created = DateTime.Now;
query.pm_modified = query.pm_created;
query.pm_create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.pm_modify_user = query.pm_create_user;
if (_pageMetaMgr.InsertPageMeta(query) > 0)
{
json = "{success:true}";
}
}
else
{
query.pm_modified = query.pm_created;
query.pm_modify_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
if (_pageMetaMgr.UpdatePageMeta(query) > 0)
{
json = "{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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}