public HttpResponseBase SaveBannerNewsContent() { string json = string.Empty; try { bncMgr = new BannerNewsContentMgr(mySqlConnectionString); BannerNewsContentQuery query = new BannerNewsContentQuery(); if (!string.IsNullOrEmpty(Request.Params["news_id"])) {//如果是編輯獲取該id數據 query.news_id = uint.Parse(Request.Params["news_id"]); } if (!string.IsNullOrEmpty(Request.Params["news_site_id"])) { query.news_site_id = uint.Parse(Request.Params["news_site_id"]); } if (!string.IsNullOrEmpty(Request.Params["news_title"])) { query.news_title = Request.Params["news_title"]; } if (!string.IsNullOrEmpty(Request.Params["news_link_url"])) { query.news_link_url = Request.Params["news_link_url"]; } if (!string.IsNullOrEmpty(Request.Params["news_link_mode"])) { query.news_link_mode = Convert.ToInt32(Request.Params["news_link_mode"]); } if (!string.IsNullOrEmpty(Request.Params["news_sort"])) { query.news_sort = Convert.ToUInt32(Request.Params["news_sort"]); } if (!string.IsNullOrEmpty(Request.Params["news_status"])) { query.news_status = Convert.ToUInt32(Request.Params["news_status"]); } if (!string.IsNullOrEmpty(Request.Params["news_start"])) { query.news_start = uint.Parse(CommonFunction.GetPHPTime(Request.Params["news_start"].Substring(0, 10) + " 00:00:00").ToString()); } if (!string.IsNullOrEmpty(Request.Params["news_end"])) { query.news_end = uint.Parse(CommonFunction.GetPHPTime(Request.Params["news_end"].Substring(0, 10) + " 23:59:59").ToString()); } query.news_createdate = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString()); query.news_updatedate = query.news_createdate; query.news_ipfrom = CommonFunction.GetClientIPNew(); if (query.news_ipfrom == "::1") { query.news_ipfrom = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName())[2].ToString(); } if (query.news_id > 0) {//編輯 if (bncMgr.UpdateBannerNewsContent(query) > 0) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:false,msg:'修改失敗!'}"; } } else {//新增 if (bncMgr.SaveBannerNewsContent(query) > 0) { json = "{success:true,msg:'新增成功!'}"; } else { json = "{success:false,msg:'新增失敗!'}"; } } } 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,msg:'操作失敗!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> ///內容和歷史跳轉鏈接頁面 文字廣告列表 /// </summary> /// <returns></returns> public HttpResponseBase GetBannerNewsList() { string json = string.Empty; BannerNewsContent query = new BannerNewsContent(); try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 if (!string.IsNullOrEmpty(Request.Params["sid"])) { query.news_site_id = uint.Parse(Request.Params["sid"]); } if (Request.Params["history"] == "1") { query.news_status = 3; } bncMgr = new BannerNewsContentMgr(mySqlConnectionString); int totalCount = 0; DataTable dt = bncMgr.GetBannerNewsContentList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss "; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dt, 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }