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