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