public List<SitePageQuery> GetSitePageList(SitePageQuery store, out int totalCount)
{
try
{
return _BannerPageDao.GetSitePageList(store, out totalCount);
}
catch (Exception ex)
{
throw new Exception("SitePageMgr-->GetBannerPageList-->" + ex.Message, ex);
}
}
public int Update(SitePageQuery model)
{
try
{
return _BannerPageDao.Update(model);
}
catch (Exception ex)
{
throw new Exception("SitePageMgr-->Update-->" + ex.Message, ex);
}
}
/// <summary>
/// GetBannerPageList
/// </summary>
/// <param name="store">store</param>
/// <param name="totalCount">totalCount</param>
/// <returns></returns>
public List<SitePageQuery> GetSitePageList(SitePageQuery store, out int totalCount)
{
store.Replace4MySQL();
StringBuilder sql = new StringBuilder();
StringBuilder sqlCount = new StringBuilder();
StringBuilder sqlFrom = new StringBuilder();
StringBuilder sqlWhere = new StringBuilder();
totalCount = 0;
sqlCount.AppendFormat("select count(sp.page_id) as totalCount ");
sql.AppendFormat(" select sp.page_id, sp.page_name,sp.page_url,sp.page_status,sp.page_html,sp.page_desc,sp.page_createdate,sp.page_updatedate,sp.create_userid,sp.update_userid");
sqlFrom.AppendFormat(" from site_page sp ");
if (!string.IsNullOrEmpty(store.page_name))
{
sqlWhere.AppendFormat(" and sp.page_name like N'%{0}%'", store.page_name);
}
if (sqlWhere.Length != 0)
{
sqlFrom.Append(" WHERE ");
sqlFrom.Append(sqlWhere.ToString().TrimStart().Remove(0, 3));
}
if (store.IsPage)
{
DataTable _dt = _accessMySql.getDataTable(sqlCount.ToString() + sqlFrom.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
}
}
sqlFrom.AppendFormat(" order by sp.page_id desc limit {0},{1};", store.Start, store.Limit);
try
{
return _accessMySql.getDataTableForObj<SitePageQuery>(sql.ToString() + sqlFrom.ToString());
}
catch (Exception ex)
{
throw new Exception("SitePageDao-->GetSitePageList-->" + ex.Message + sql.ToString() + sqlFrom.ToString(), ex);
}
}
public HttpResponseBase SaveSitePage()
{
string json = string.Empty;
SitePageQuery query = new SitePageQuery();
_sitePageMg = new SitePageMgr(mySqlConnectionString);
try
{
if (string.IsNullOrEmpty(Request.Params["page_id"]))
{
if (!string.IsNullOrEmpty(Request.Params["page_name"]))
{
query.page_name = Request.Params["page_name"];
}
else
{
query.page_name = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["page_url"]))
{
query.page_url = Request.Params["page_url"];
}
else
{
query.page_url = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["page_html"]))
{
query.page_html = Request.Params["page_html"];
}
else
{
query.page_html = string.Empty;
}
query.page_desc = Request.Params["page_desc"];
query.page_status = 0;
query.page_createdate = DateTime.Now;
query.page_updatedate = DateTime.Now;
query.create_userid = (Session["caller"] as Caller).user_id;
query.update_userid = (Session["caller"] as Caller).user_id;
_sitePageMg.Save(query);
json = "{success:true}";
}
else
{
query.page_id = Convert.ToInt32(Request.Params["page_id"]);
query.page_name = Request.Params["page_name"];
query.page_url = Request.Params["page_url"];
query.page_html = Request.Params["page_html"];
query.page_desc = Request.Params["page_desc"];
query.page_status = 0;
query.page_updatedate = DateTime.Now;
query.update_userid = (Session["caller"] as Caller).user_id;
_sitePageMg.Update(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 JsonResult UpdateSitePageStatus()
{
string json = string.Empty;
try
{
SitePageQuery query = new SitePageQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.page_id = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.page_status = Convert.ToInt32(Request.Params["active"]);
}
query.page_updatedate = DateTime.Now;
query.update_userid = (Session["caller"] as Caller).user_id;
_sitePageMg = new SitePageMgr(mySqlConnectionString);
if (_sitePageMg.UpdateStatus(query) > 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" });
}
}
//public HttpResponseBase Getpic()
//{//判斷該文件是否超過限制
// string Json = "";
// FileManagement fileLoad = new FileManagement();
// string path = Server.MapPath(xmlPath);
// SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
// SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_Min_Element");
// SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
// //擴展名、最小值、最大值
// string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
// string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
// //if (Request.Files.Count > 0)//單個圖片上傳
// for (int iFile = 0; iFile < Request.Files.Count; iFile++)//多個上傳圖片
// {
// HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0]
// int fileSize = file.ContentLength;
// if (fileSize > int.Parse(minValue) && fileSize < int.Parse(maxValue))
// {
// Json = "{success:true}";
// }
// else
// {
// Json = "{success:false}";
// }
// }
// this.Response.Clear();
// this.Response.Write(Json);
// this.Response.End();
// return this.Response;
//}
#endregion
#region 站台頁面管理
#region 頁面列表頁 +HttpResponseBase SitePageList()
public HttpResponseBase SitePageList()
{
List<SitePageQuery> store = new List<SitePageQuery>();
string json = string.Empty;
SitePageQuery query = new SitePageQuery();
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
//if (!string.IsNullOrEmpty(Request.Params["site"]))
//{
// query.site_name = Request.Params["site"];
//}
//else
//{
// query.site_id = 0;
//}
if (!string.IsNullOrEmpty(Request.Params["pagename"]))
{
query.page_name = Request.Params["pagename"];
}
else
{
query.page_name = string.Empty;
}
_sitePageMg = new SitePageMgr(mySqlConnectionString);
int totalCount = 0;
query.create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
store = _sitePageMg.GetSitePageList(query, out totalCount);
foreach (var item in store)
{
if (item.page_html.Length >= 15)
{
item.page_shortHtml = item.page_html.Substring(0, 15) + "...";
}
else
{
item.page_shortHtml = item.page_html;
}
}
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 int Update(SitePageQuery model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" UPDATE site_page SET page_name='{0}',page_url='{1}',page_html='{2}',page_desc='{3}',page_updatedate='{4}',update_userid='{5}' WHERE page_id='{6}' ", model.page_name, model.page_url, model.page_html, model.page_desc, CommonFunction.DateTimeToString(model.page_updatedate), model.update_userid, model.page_id);
try
{
return _accessMySql.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("SitePageDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
public int Save(SitePageQuery model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("INSERT INTO site_page(page_name,page_url,page_status,page_html,page_desc,page_createdate,page_updatedate,create_userid,update_userid)");
sql.AppendFormat(" values('{0}','{1}','{2}',", model.page_name, model.page_url, model.page_status);
sql.AppendFormat(" '{0}','{1}','{2}','{3}',", model.page_html, model.page_desc, CommonFunction.DateTimeToString(model.page_createdate), CommonFunction.DateTimeToString(model.page_updatedate));
sql.AppendFormat("'{0}','{1}')", model.create_userid, model.update_userid);
try
{
return _accessMySql.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("SitePageDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public int UpdateStatus(SitePageQuery query)
{
query.Replace4MySQL();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update site_page set page_status={0},page_updatedate='{1}',update_userid={2} where page_id={3}", query.page_status, CommonFunction.DateTimeToString(query.page_updatedate), query.update_userid, query.page_id);
try
{
int result = _accessMySql.execCommand(sql.ToString());
return result;
}
catch (Exception ex)
{
throw new Exception("SitePageDao-->UpdateStatus-->" + ex.Message + sql.ToString(), ex);
}
}
public int UpdateStatus(SitePageQuery query)
{
try
{
return _BannerPageDao.UpdateStatus(query);
}
catch (Exception ex)
{
throw new Exception("SitePageMgr-->UpdateStatus-->" + ex.Message, ex);
}
}
