public string Save(RedirectGroup query) { StringBuilder sql = new StringBuilder(""); try { query.Replace4MySQL(); sql.Append(" INSERT INTO redirect_group(group_id,group_name,group_createdate,group_updatedate,group_ipfrom,group_type) "); sql.AppendFormat(" VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')", query.group_id, query.group_name, query.group_createdate, query.group_updatedate, query.group_ipfrom,query.group_type); return sql.ToString(); } catch (Exception ex) { throw new Exception("RedirectGroupDao-->Save-->" + ex.Message + sql.ToString(), ex); } }
public int Update(RedirectGroup query) { StringBuilder sql = new StringBuilder(""); try { query.Replace4MySQL(); sql.AppendFormat("UPDATE redirect_group set "); sql.AppendFormat(" group_name='{0}',group_updatedate='{1}',group_ipfrom='{2}',group_type='{3}' ", query.group_name, query.group_updatedate, query.group_ipfrom,query.group_type); sql.AppendFormat(" WHERE group_id='{0}' ;", query.group_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("RedirectGroupDao-->Update-->" + ex.Message + sql.ToString(), ex); } }
public List<RedirectGroupQuery> QueryAll(RedirectGroup query, out int totalCount) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); StringBuilder sqlConi = new StringBuilder(); sqlConi.Append(" SELECT group_id,group_name,group_createdate, FROM_UNIXTIME(group_createdate) createdate,group_updatedate,FROM_UNIXTIME(group_updatedate) updatedate,group_ipfrom,group_type,t.parameterName "); sql.Append(" FROM redirect_group left join t_parametersrc t on group_type = t.parameterCode AND t.parameterType='group_type' WHERE 1=1 "); if (query.group_id != 0) { sql.AppendFormat(" AND group_id={0}", query.group_id); } if(!string.IsNullOrEmpty(query.group_name)) { sql.AppendFormat(" AND group_name LIKE '%{0}%' ", query.group_name); } if (!string.IsNullOrEmpty(query.group_type)) { sql.AppendFormat(" AND group_type ='{0}' ", query.group_type); } sql.Append(" ORDER BY group_name "); totalCount = 0; if (query.IsPage) { StringBuilder consql = new StringBuilder("SELECT count(group_id) "); DataTable dt = _access.getDataTable(consql.ToString() + sql.ToString()); if (dt != null && dt.Rows.Count > 0) { totalCount = Convert.ToInt32(dt.Rows[0][0].ToString()); } sql.AppendFormat(" LIMIT {0},{1};", query.Start, query.Limit); } return _access.getDataTableForObj<RedirectGroupQuery>(sqlConi.ToString() + sql.ToString()); } catch (Exception ex) { throw new Exception("RedirectGroupDao-->QueryAll-->" + ex.Message + sql.ToString(), ex); } }