public static List <County> SearchCountyOfDistrict(string dd, string concelho, int limit, int offset) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(`{0}` like @{0})", County.Column.concelho.ToString())) .Append(" AND ") .Append(string.Format("(`{0}` = @{0})", County.Column.dd.ToString())) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + County.Column.concelho.ToString(), "%" + concelho.Trim().Replace(" ", "%") + "%")); lp.Add(new MySqlParameter("@" + County.Column.dd.ToString(), dd)); return(County.ExecuteQuery(sql, lp, limit, offset)); }
public static List <County> GetCounty(string dd, string cc, int limit, int offset) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(`{0}` = @{0})", County.Column.cc.ToString())) .Append(" AND ") .Append(string.Format("(`{0}` = @{0})", County.Column.dd.ToString())) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + County.Column.cc.ToString(), cc)); lp.Add(new MySqlParameter("@" + County.Column.dd.ToString(), dd)); return(County.ExecuteQuery(sql, lp, limit, offset)); }
protected static List <County> ExecuteQuery(string sql, List <MySqlParameter> param, int limit, int offset) { List <County> l = new List <County>(); CpMySql my = new CpMySql(); MySqlDataReader r = my.ExecuteCommand(sql, param, limit, offset); while (r.Read()) { County d = new County { dd = r.GetString(r.GetOrdinal(County.Column.dd.ToString())), district = r.GetString(r.GetOrdinal(County.Column.distrito.ToString())), cc = r.GetString(r.GetOrdinal(County.Column.cc.ToString())), county = r.GetString(r.GetOrdinal(County.Column.concelho.ToString())) }; l.Add(d); } my.Command.Dispose(); r.Close(); my.Conection.Close(); return(l); }
public static List <County> GetAll(int limit, int offset) { return(County.ExecuteQuery(BSql, new List <MySqlParameter>(), limit, offset)); }