public HttpResponseBase GetEpaperById()
{
string json = string.Empty;
EpaperContentQuery store = new EpaperContentQuery();
EpaperContentQuery query = new EpaperContentQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["rowid"]))
{
_IEpaperContentMgr = new EpaperContentMgr(mySqlConnectionString);
store.epaper_id = Convert.ToUInt32(Request.Params["rowid"]);
store = _IEpaperContentMgr.GetEpaperContentById(store);
store.epaper_content = Server.HtmlDecode(store.epaper_content);
store.epaperShowStart = CommonFunction.GetNetTime(store.epaper_show_start);
store.epaperShowEnd = CommonFunction.GetNetTime(store.epaper_show_end);
store.epaperCreateDate = CommonFunction.GetNetTime(store.epaper_createdate);
store.epaperUpdateDate = CommonFunction.GetNetTime(store.epaper_updatedate);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true" + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
else
{
json = "{success:false,data:[]}";
}
}
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 GetEpaperContentList()
{
string json = string.Empty;
List<EpaperContentQuery> store = new List<EpaperContentQuery>();
EpaperContentQuery query = new EpaperContentQuery();
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
_IEpaperContentMgr = new EpaperContentMgr(mySqlConnectionString);
int totalCount = 0;
if (!string.IsNullOrEmpty(Request.Params["searchCon"]))
{
query.searchCon = Request.Params["searchCon"];
}
if (!string.IsNullOrEmpty(Request.Params["search_text"]))
{
query.search_text = Request.Params["search_text"];
}
if (!string.IsNullOrEmpty(Request.Params["dateCon"]))
{
query.dateCon = Request.Params["dateCon"];
}
if (!string.IsNullOrEmpty(Request.Params["date_start"]))
{
query.epaperShowStart = Convert.ToDateTime(Request.Params["date_start"]);
}
if (!string.IsNullOrEmpty(Request.Params["date_end"]))
{
query.epaperShowEnd = Convert.ToDateTime(Request.Params["date_end"]);
}
if (!string.IsNullOrEmpty(Request.Params["activeStatus"]))
{
query.epaperStatus = Request.Params["activeStatus"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["sizeCon"]))
{
query.epaper_size = Request.Params["sizeCon"];
}
store = _IEpaperContentMgr.GetEpaperContentList(query, out totalCount);
foreach (var item in store)
{
item.epaperShowStart = CommonFunction.GetNetTime(item.epaper_show_start);
item.epaperShowEnd = CommonFunction.GetNetTime(item.epaper_show_end);
item.epaperCreateDate = CommonFunction.GetNetTime(item.epaper_createdate);
item.epaperUpdateDate = CommonFunction.GetNetTime(item.epaper_updatedate);
item.epaper_content = Server.HtmlDecode(Server.HtmlDecode(item.epaper_content));
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
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 SaveEpaperContent()
{
string json = string.Empty;
List<EpaperContentQuery> store = new List<EpaperContentQuery>();
EpaperContentQuery OldQuery = new EpaperContentQuery();
EpaperContentQuery query = new EpaperContentQuery();
_IEpaperContentMgr = new EpaperContentMgr(mySqlConnectionString);
try
{
query.user_id = uint.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
if (string.IsNullOrEmpty(Request.Params["epaper_id"]))//新增
{
if (!string.IsNullOrEmpty(Request.Params["epaper_title"]))
{
query.epaper_title = Request.Params["epaper_title"];
}
if (!string.IsNullOrEmpty(Request.Params["epaper_short_title"]))
{
query.epaper_short_title = Request.Params["epaper_short_title"];
}
if (!string.IsNullOrEmpty(Request.Params["epaper_size"]))
{
query.epaper_size = Request.Params["epaper_size"];
}
if (!string.IsNullOrEmpty(Request.Params["type"]))
{
query.type = Convert.ToUInt32(Request.Params["type"]);
}
if (!string.IsNullOrEmpty(Request.Params["epaper_sort"]))
{
query.epaper_sort = Convert.ToUInt32(Request.Params["epaper_sort"]);
}
if (!string.IsNullOrEmpty(Request.Params["epaperShowStart"]))
{
query.epaperShowStart = Convert.ToDateTime(Request.Params["epaperShowStart"]);
}
if (!string.IsNullOrEmpty(Request.Params["epaperShowEnd"]))
{
query.epaperShowEnd = Convert.ToDateTime(Request.Params["epaperShowEnd"]);
}
if (!string.IsNullOrEmpty(Request.Params["kendoEditor"]))
{
query.epaper_content = Request.Params["kendoEditor"];
}
if (!string.IsNullOrEmpty(Request.Params["type"]))
{
if (Request.Params["newsType"] == "direct")//直接上稿
{
query.epaper_status = 1;
}
else
{
query.epaper_status = 0;
}
}
System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
if (addlist.Length > 0)
{
query.epaper_ipfrom = addlist[0].ToString();
}
query.epaperCreateDate = DateTime.Now;
query.epaperUpdateDate = query.epaperCreateDate;
query.log_description = "add";
_IEpaperContentMgr.SaveEpaperContent(query);
json = "{success:true}";
}
else
{
query.epaper_id = Convert.ToUInt32(Request.Params["epaper_id"]);
OldQuery = _IEpaperContentMgr.GetEpaperContentById(query);
if (!string.IsNullOrEmpty(Request.Params["epaper_title"]))
{
query.epaper_title = Request.Params["epaper_title"];
}
else
{
query.epaper_title = OldQuery.epaper_title;
}
if (!string.IsNullOrEmpty(Request.Params["epaper_short_title"]))
{
query.epaper_short_title = Request.Params["epaper_short_title"];
}
if (!string.IsNullOrEmpty(Request.Params["epaper_size"]))
{
query.epaper_size = Request.Params["epaper_size"];
}
else
{
query.epaper_size = OldQuery.epaper_size;
}
if (!string.IsNullOrEmpty(Request.Params["type"]))
{
query.type = Convert.ToUInt32(Request.Params["type"]);
}
else
{
query.type = OldQuery.type;
}
if (!string.IsNullOrEmpty(Request.Params["epaper_sort"]))
{
query.epaper_sort = Convert.ToUInt32(Request.Params["epaper_sort"]);
}
else
{
query.epaper_sort = OldQuery.epaper_sort;
}
if (!string.IsNullOrEmpty(Request.Params["epaperShowStart"]))
{
query.epaperShowStart = Convert.ToDateTime(Request.Params["epaperShowStart"]);
}
else
{
query.epaperShowStart = OldQuery.epaperShowStart;
}
if (!string.IsNullOrEmpty(Request.Params["epaperShowEnd"]))
{
query.epaperShowEnd = Convert.ToDateTime(Request.Params["epaperShowEnd"]);
}
else
{
query.epaperShowEnd = OldQuery.epaperShowEnd;
}
if (!string.IsNullOrEmpty(Request.Params["kendoEditor"]))
{
query.epaper_content = Request.Params["kendoEditor"];
}
else
{
query.epaper_content = OldQuery.epaper_content;
}
if (!string.IsNullOrEmpty(Request.Params["epaper_status"]))
{
query.epaper_status = Convert.ToUInt32(Request.Params["epaper_status"]);
}
else
{
query.epaper_status = OldQuery.epaper_status;
}
if (!string.IsNullOrEmpty(Request.Params["fb_description"]))
{
query.fb_description = Request.Params["fb_description"];
}
else
{
query.fb_description = OldQuery.fb_description;
}
System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
if (addlist.Length > 0)
{
query.epaper_ipfrom = addlist[0].ToString();
}
query.epaperUpdateDate = DateTime.Now;
query.log_description = "modify,status=" + query.epaper_status;
_IEpaperContentMgr.SaveEpaperContent(query);
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetEpaperLogList()
{
string json = string.Empty;
List<EpaperLogQuery> store = new List<EpaperLogQuery>();
EpaperLogQuery query = new EpaperLogQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["epaperId"]))
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
query.epaper_id = Convert.ToUInt32(Request.Params["epaperId"]);
_IEpaperContentMgr = new EpaperContentMgr(mySqlConnectionString);
int totalCount = 0;
store = _IEpaperContentMgr.GetEpaperLogList(query, out totalCount);
foreach (var item in store)
{
item.LogCreateDate = CommonFunction.GetNetTime(item.log_createdate);
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
else
{
json = "{success:false,totalCount:0,data:[]}";
}
}
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 GetEpaperContent()
{
string json = string.Empty;
try
{
_epaperContentMgr = new EpaperContentMgr(mySqlConnectionString);
json = _epaperContentMgr.GetEpaperContent();
}
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 HttpResponseBase GetEpaperContent()
{
string json = string.Empty;
List<EpaperContent> store = new List<EpaperContent>();
EpaperContent query = new EpaperContent();
try
{
_epaperMgr = new EpaperContentMgr(mySqlConnectionString);
store = _epaperMgr.GetEpaperContentLimit();
EpaperContent zero = new EpaperContent();
zero.epaper_title = "請選擇...";
store.Insert(0, zero);
foreach (var item in store)
{
item.epaper_content = Server.HtmlDecode(item.epaper_content);
}
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 HttpResponseBase LoadEpaperContent()
{
string json = string.Empty;
EpaperContentQuery query = new EpaperContentQuery();
EpaperContentQuery model = new EpaperContentQuery();
try
{
if (!string.IsNullOrEmpty(Request.Params["content_id"]))
{
_IEdmContentMgr = new EdmContentMgr(mySqlConnectionString);
query.epaper_id = Convert.ToUInt32(Request.Params["content_id"]);
_epaperMgr = new EpaperContentMgr(mySqlConnectionString);
model = _epaperMgr.GetEpaperContentById(query);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
if (model != null)
{
model.epaper_id = query.epaper_id;
switch (model.epaper_status)
{
case 0:
json = "{success:false" + ",data:" + JsonConvert.SerializeObject(model, Formatting.Indented, timeConverter) + ",msg:0}";
break;
case 1:
json = "{success:true" + ",data:" + JsonConvert.SerializeObject(model, Formatting.Indented, timeConverter) + "}";
break;
case 2:
json = "{success:false" + ",data:" + JsonConvert.SerializeObject(model, Formatting.Indented, timeConverter) + ",msg:1}";
break;
case 3:
json = "{success:false" + ",data:" + JsonConvert.SerializeObject(model, Formatting.Indented, timeConverter) + ",msg:2}";
break;
}
}
else
{
json = "{success:false,msg:3}";
}
}
else
{
json = "{success:false,data:[]}";
}
}
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;
}