Пример #1
0
 public int UpdateBannerNewsContent(BannerNewsContentQuery q)
 {
     try
     {
         return _bannerNewsContent.UpdateBannerNewsContent(q);
     }
     catch (Exception ex)
     {
         throw new Exception("BannerNewsContentMgr-->UpdateBannerNewsContent" + ex.Message, ex);
     }
 }
Пример #2
0
 public int UpdateBannerNewsContent(BannerNewsContentQuery q)
 {
     StringBuilder sql = new StringBuilder();
     try
     {
         sql.AppendFormat(@" update banner_news_content  ");
         sql.AppendFormat(@" set news_title='{0}',news_link_url='{1}',news_link_mode='{2}',news_sort='{3}', ", q.news_title, q.news_link_url, q.news_link_mode, q.news_sort);
         sql.AppendFormat(@" news_start='{0}',news_end='{1}',news_updatedate='{2}', ", q.news_start, q.news_end,q.news_updatedate);
         sql.AppendFormat(@" news_status='{0}' ",q.news_status);
         sql.AppendFormat(" where news_id='{0}' ;",q.news_id);
         return _access.execCommand(sql.ToString());
     }
     catch (Exception ex)
     {
         throw new Exception("BannerNewsContentDao-->UpdateBannerNewsContent" + ex.Message + sql.ToString(), ex);
     }
 }
Пример #3
0
 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;
 }
Пример #4
0
 public int SaveBannerNewsContent(BannerNewsContentQuery q)
 {
     StringBuilder sb = new StringBuilder();
     DataTable dt = new DataTable();
     try
     {
         sb.Append("SELECT * FROM serial where serial_id='8';");
         dt = _access.getDataTable(sb.ToString());
         if (dt.Rows.Count > 0)
         {
             q.news_id = uint.Parse(dt.Rows[0]["serial_value"].ToString()) + 1;
             sb.Clear();
             sb.Append("insert into banner_news_content(news_id,news_site_id,news_title,news_content,news_link_url,news_link_mode,news_sort,news_status,news_start,news_end,news_createdate,news_updatedate,news_ipfrom) Value(");
             sb.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}');", q.news_id, q.news_site_id, q.news_title, q.news_content, q.news_link_url, q.news_link_mode, q.news_sort, q.news_status, q.news_start, q.news_end, q.news_createdate, q.news_updatedate, q.news_ipfrom);
             sb.AppendFormat("update serial set serial_value='{0}' where serial_id='8'; ", q.news_id);
             return _access.execCommand(sb.ToString());
         }
         else
         {
             return 0;
         }
     }
     catch (Exception ex)
     {
         throw new Exception("BannerNewsContentDao-->SaveBannerNewsContent" + ex.Message + sb.ToString(), ex);
     }
 }