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); } }