public MySqlDataReader Search(ClosingItemStatus ClosingItemstatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
string SQL = "SELECT " +
"ClosingItemID, " +
"ClosingID, " +
"ProductID, " +
"ProductCode, " +
"BarCode, " +
"Description, " +
"ProductUnitID, " +
"ProductUnitCode, " +
"Quantity, " +
"UnitCost, " +
"Discount, " +
"InPercent, " +
"TotalDiscount, " +
"Amount, " +
"VAT, " +
"VatableAmount, " +
"EVAT, " +
"EVatableAmount, " +
"LocalTax, " +
"VariationMatrixID, " +
"MatrixDescription, " +
"ProductGroup, " +
"ProductSubGroup, " +
"ClosingItemStatus, " +
"IsVatable, " +
"Remarks " +
"FROM tblClosingItems " +
"WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " +
"or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " +
"or Remarks LIKE @SearchKey) " +
"ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmClosingItemStatus = new MySqlParameter("@ClosingItemStatus",MySqlDbType.Int16);
prmClosingItemStatus.Value = ClosingItemstatus.ToString("d");
cmd.Parameters.Add(prmClosingItemStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
MySqlDataReader myReader = base.ExecuteReader(cmd);
return myReader;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public MySqlDataReader Search(ClosingItemStatus ClosingItemstatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
string SQL = "SELECT " +
"ClosingItemID, " +
"ClosingID, " +
"ProductID, " +
"ProductCode, " +
"BarCode, " +
"Description, " +
"ProductUnitID, " +
"ProductUnitCode, " +
"Quantity, " +
"UnitCost, " +
"Discount, " +
"InPercent, " +
"TotalDiscount, " +
"Amount, " +
"VAT, " +
"VatableAmount, " +
"EVAT, " +
"EVatableAmount, " +
"LocalTax, " +
"VariationMatrixID, " +
"MatrixDescription, " +
"ProductGroup, " +
"ProductSubGroup, " +
"ClosingItemStatus, " +
"IsVatable, " +
"Remarks " +
"FROM tblClosingItems " +
"WHERE (ProductCode LIKE @SearchKey or BarCode LIKE @SearchKey or Description LIKE @SearchKey " +
"or MatrixDescription LIKE @SearchKey or ProductGroup LIKE @SearchKey or ProductSubGroup LIKE @SearchKey " +
"or Remarks LIKE @SearchKey) " +
"ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
{
SQL += " ASC";
}
else
{
SQL += " DESC";
}
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmClosingItemStatus = new MySqlParameter("@ClosingItemStatus", MySqlDbType.Int16);
prmClosingItemStatus.Value = ClosingItemstatus.ToString("d");
cmd.Parameters.Add(prmClosingItemStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
MySqlDataReader myReader = base.ExecuteReader(cmd);
return(myReader);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
