public int UpdateBannerNewsContent(BannerNewsContentQuery q) { try { return _bannerNewsContent.UpdateBannerNewsContent(q); } catch (Exception ex) { throw new Exception("BannerNewsContentMgr-->UpdateBannerNewsContent" + ex.Message, ex); } }
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); } }
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; }
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); } }