public static DataTable GetDataTable(string filter = "", string status = "") { var sql = "select id, code, description, name, phone, fax, email, address from " + TableName + "\nwhere 1 = 1"; if (status.Length == 0) { sql += " and status <> '" + Type.RecordStatus_Deleted + "'"; } else { sql += " and status = '" + status + "'"; } if (filter.Length > 0) { sql += " and (code ilike :filter or description ilike :filter or phone ilike :filter or fax ilike :filter or email ilike :filter or address ilike :filter or note ilike :filter)"; } sql += "\norder by code\nlimit " + ConfigFacade.sy_select_limit; var cmd = new NpgsqlCommand(sql); if (filter.Length > 0) { cmd.Parameters.AddWithValue(":filter", "%" + filter + "%"); } return(SqlFacade.GetDataTable(cmd)); }
public static DataTable GetDataTable(string filter = "", string status = "") { var sql = SqlFacade.SqlSelect(TableName, "id, branch_code, code, description, type, name, phone, fax, email, address", "1 = 1"); if (status.Length == 0) { sql += " and status <> '" + Type.RecordStatus_Deleted + "'"; } else { sql += " and status = '" + status + "'"; } if (filter.Length > 0) { sql += " and (" + SqlFacade.SqlILike("code, description, phone, fax, email, address, note") + ")"; } sql += "\norder by code\nlimit " + ConfigFacade.sy_select_limit; var cmd = new NpgsqlCommand(sql); if (filter.Length > 0) { cmd.Parameters.AddWithValue(":filter", "%" + filter + "%"); } return(SqlFacade.GetDataTable(cmd)); }