public string Save(Redirect query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.Append(" INSERT INTO redirect(redirect_id,group_id,user_group_id,redirect_name,redirect_url,"); sql.Append(" redirect_status,redirect_total, redirect_note,redirect_createdate,redirect_updatedate,redirect_ipfrom ) "); sql.AppendFormat(" VALUES ('{0}','{1}','{2}','{3}','{4}',", query.redirect_id, query.group_id, query.user_group_id, query.redirect_name, query.redirect_url); sql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}')", query.redirect_status, query.redirect_total, query.redirect_note, query.redirect_createdate, query.redirect_updatedate, query.redirect_ipfrom); return sql.ToString(); } catch (Exception ex) { throw new Exception("RedirectDao-->Save-->" + ex.Message + sql.ToString(), ex); } }
public HttpResponseBase SaveRedirect() { string json = string.Empty; try { Redirect redirect = new Redirect(); _redirectMgr = new RedirectMgr(mySqlConnectionString); _serialMgr = new SerialMgr(mySqlConnectionString); redirect.redirect_name = Request.Params["redirect_name"].ToString(); if (!string.IsNullOrEmpty(Request.Params["group_id"])) { redirect.group_id = uint.Parse(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["user_group_id"])) { redirect.user_group_id = int.Parse(Request.Params["user_group_id"]); } if (!string.IsNullOrEmpty(Request.Params["redirect_status"])) { redirect.redirect_status = uint.Parse(Request.Params["redirect_status"]); } redirect.redirect_url = Request.Params["redirect_url"]; redirect.redirect_note = Request.Params["redirect_note"]; redirect.redirect_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString(); if (!string.IsNullOrEmpty(Request.Params["redirect_id"])) { redirect.redirect_id = uint.Parse(Request.Params["redirect_id"]); redirect.redirect_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime()); if (_redirectMgr.Update(redirect) > 0) { json = "{success:true}"; } } else { redirect.redirect_id = uint.Parse((_serialMgr.GetSerialById(4).Serial_Value + 1).ToString()); redirect.redirect_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime()); redirect.redirect_updatedate = redirect.redirect_createdate; if (_redirectMgr.Save(redirect) > 0) { Serial serial = new Serial(); serial.Serial_id = 4; serial.Serial_Value = redirect.redirect_id; _serialMgr.Update(serial); 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int Update(Redirect query) { StringBuilder sql = new StringBuilder(""); try { query.Replace4MySQL(); sql.AppendFormat("UPDATE redirect set "); sql.AppendFormat(" group_id='{0}',user_group_id='{1}',redirect_name='{2}',", query.group_id, query.user_group_id, query.redirect_name); sql.AppendFormat(" redirect_url='{0}',redirect_status='{1}',", query.redirect_url, query.redirect_status); sql.AppendFormat(" redirect_note='{0}',redirect_updatedate='{1}',redirect_ipfrom='{2}'", query.redirect_note, query.redirect_updatedate, query.redirect_ipfrom); sql.AppendFormat(" WHERE redirect_id='{0}' ;", query.redirect_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("RedirectDao-->Update-->" + ex.Message + sql.ToString(), ex); } }