public static List <CPostal> Search(string searchString, int limit, int offset) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(searchString) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); return(CPostal.ExecuteQuery(sql, lp, limit, offset)); }
public static List <CPostal> SerachByCliente(string cliente, int limit, int offset) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(`{0}` like @{0})", CPostal.Column.cliente.ToString())) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + CPostal.Column.cliente.ToString(), "%" + cliente.Trim().Replace(' ', '%') + "%")); return(CPostal.ExecuteQuery(sql, lp, limit, offset)); }
/// <summary> /// Get a client from database /// </summary> /// <param name="client"></param> /// <returns></returns> public static List <CPostal> GetClient(string client) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(`{0}` = @{0})", CPostal.Column.cliente.ToString())) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + CPostal.Column.cliente.ToString(), client)); return(CPostal.ExecuteQuery(sql, lp, 1, 0)); }
public static List <CPostal> SearchByCpostal(string cp, int limit, int offset) { string p1 = "p"; string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(CONCAT(`{0}`,`{1}`) like @{2})", CPostal.Column.cp4, CPostal.Column.cp3, p1)) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + p1, "%" + Regex.Replace(cp.Trim().Replace("-", "%").Replace(" ", "%"), @"\s?\D?", "") + "%")); return(CPostal.ExecuteQuery(sql, lp, limit, offset)); }
public static List <CPostal> SearchByDisAddress(string distrito, string address, int limit, int offset) { string sql = new StringBuilder(BSql) .Append(" WHERE ") .Append(string.Format("(`{0}` like @{0})", CPostal.Column.morada.ToString())) .Append(" AND ") .Append(string.Format("(`{0}` = @{0})", CPostal.Column.distrito.ToString())) .ToString(); List <MySqlParameter> lp = new List <MySqlParameter>(); lp.Add(new MySqlParameter("@" + CPostal.Column.morada.ToString(), "%" + address.Trim().Replace(' ', '%') + "%")); lp.Add(new MySqlParameter("@" + CPostal.Column.distrito.ToString(), distrito)); return(CPostal.ExecuteQuery(sql, lp, limit, offset)); }