/*
編輯的預覽按鈕和列表頁的預覽都訪問這個方法
* 1.
*
*/
public HttpResponseBase GetPreviewHtml()
{
string html = string.Empty;
string replaceStr = string.Empty;
string contentStr = string.Empty;
string templateStr = string.Empty;
string recommendStr = string.Empty;
string previewStr = string.Empty;
string editStr = string.Empty;
try
{
_edmContentNewMgr = new EdmContentNewMgr(mySqlConnectionString);
EdmContentNew query = new EdmContentNew();
//將傳過來的html加上根據當前登入者的id獲得的推薦html替換掉content_url中的替換符
if (!string.IsNullOrEmpty(Request.Params["content_id"]))
{
query.content_id = Convert.ToInt32(Request.Params["content_id"]);
string content_url = _edmContentNewMgr.GetContentUrlByContentId(query.content_id);
if (!string.IsNullOrEmpty(content_url))
{
#region 獲取網頁內容
HttpWebRequest httpRequest = (HttpWebRequest)WebRequest.Create(content_url);
httpRequest.Timeout = 9000;
httpRequest.Method = "GET";
HttpWebResponse httpResponse = (HttpWebResponse)httpRequest.GetResponse();
StreamReader sr = new StreamReader(httpResponse.GetResponseStream(), System.Text.Encoding.GetEncoding("UTF-8"));
contentStr = sr.ReadToEnd();
#endregion
}
else
{
contentStr = "";
}
}
//列表頁的預覽按鈕不進這個方法
if (!string.IsNullOrEmpty(Request.Params["template_id"]))
{
query.template_id = Convert.ToInt32(Request.Params["template_id"]);
edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
if (edmtemplatemgr.GetStaticTemplate(query.template_id))
{
recommendStr = string.Empty;
}
else
{
recommendStr = _edmContentNewMgr.GetRecommendHtml(Convert.ToUInt32((Session["caller"] as Caller).user_id));
}
}
//獲取template_data（編輯器中的內容或者是表中的template_data）
if (!string.IsNullOrEmpty(Request.Params["template_data"]))
{
templateStr = Request.Params["template_data"];
}
else
{
templateStr = _edmContentNewMgr.GetHtml(query);
}
//編輯的預覽按鈕不進這個方法
//根據user_id獲得精準推薦
if (!string.IsNullOrEmpty(Request.Params["static_template"]))
{
if (Request.Params["static_template"] == "0")// 動態範本，精準推薦
{
recommendStr = _edmContentNewMgr.GetRecommendHtml(Convert.ToUInt32((Session["caller"] as Caller).user_id));
}
else
{
recommendStr = string.Empty;
}
}
//替換符
DataTable _dt = _edmContentNewMgr.GetPraraData(1);
if (_dt != null && _dt.Rows.Count > 0)
{
replaceStr = _dt.Rows[0][0].ToString();
}
else
{
replaceStr = " ";
}
//分隔符
DataTable _dtEdit = _edmContentNewMgr.GetPraraData(3);
if (_dtEdit != null && _dtEdit.Rows.Count > 0)
{
editStr = _dtEdit.Rows[0][0].ToString();
}
else
{
editStr = " ";
}
templateStr = templateStr.Replace(editStr,"") + recommendStr;
if (Request.Params["checked"] == "true")
{
if (!string.IsNullOrEmpty(contentStr))
{
previewStr = contentStr.Replace(replaceStr, templateStr) + subscribe_url;
}
else
{
previewStr = templateStr + subscribe_url;
}
}
else
{
if (!string.IsNullOrEmpty(contentStr))
{
previewStr = contentStr.Replace(replaceStr, templateStr);
}
else
{
previewStr = templateStr;
}
}
}
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);
previewStr = "";
}
this.Response.Clear();
this.Response.Write(previewStr);
this.Response.End();
return this.Response;
}
//EdmTemplate 中的狀態啟用
public HttpResponseBase UpdateStats_ET()
{
string json = string.Empty;
try
{
edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
EdmTemplateQuery query = new EdmTemplateQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.template_id = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.enabled = Convert.ToInt32(Request.Params["active"]);
}
json = edmtemplatemgr.UpdateStats_ET(query);
}
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 SaveEdmTemplateAdd() //add by yachao1120j 2015-9-22
{
string json = string.Empty;
try
{
EdmTemplateQuery query = new EdmTemplateQuery();
edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["template_id"]))
{
query.template_id = Convert.ToInt32(Request.Params["template_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["template_name"]))
{
query.template_name = Request.Params["template_name"];
}
if (!string.IsNullOrEmpty(Request.Params["edit_url"]))
{
query.edit_url = Request.Params["edit_url"];
}
if (!string.IsNullOrEmpty(Request.Params["content_url"]))
{
query.content_url = Request.Params["content_url"];
}
if (!string.IsNullOrEmpty(Request.Params["static_template"]))
{
if (Request.Params["static_template"] == "true")
{
query.static_template = 1;
}
else
{
query.static_template = 0;
}
}
query.template_update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.template_create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int _dt = edmtemplatemgr.SaveEdmTemplateAdd(query);
if (_dt > 0)
{
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
public HttpResponseBase GetEdmTemplateList() //add by yachao1120j 2015-9-22
{
string json = string.Empty;
int totalcount = 0;
try
{
EdmTemplateQuery query = new EdmTemplateQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
edmtemplatemgr = new EdmTemplateMgr(mySqlConnectionString);
List<EdmTemplateQuery> list = edmtemplatemgr.GetEdmTemplateList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// timeConverter.DateTimeFormat = "yyyy-MM-dd ";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, 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 Response;
}