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