public MySqlDataReader Search(SOReturnItemStatus SOReturnItemstatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null)
{
SortField = "CreditMemoItemID";
}
string SQL = SQLSelect() + "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 prmSOReturnItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16);
prmSOReturnItemStatus.Value = SOReturnItemstatus.ToString("d");
cmd.Parameters.Add(prmSOReturnItemStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey", MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
MySqlDataReader myReader = (MySqlDataReader)cmd.ExecuteReader();
return(myReader);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MySqlDataReader List(SOReturnItemStatus SOReturnItemstatus, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null)
{
SortField = "CreditMemoItemID";
}
string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " +
"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 prmSOReturnItemStatus = new MySqlParameter("@ItemStatus", MySqlDbType.Int16);
prmSOReturnItemStatus.Value = SOReturnItemstatus.ToString("d");
cmd.Parameters.Add(prmSOReturnItemStatus);
MySqlDataReader myReader = (MySqlDataReader)cmd.ExecuteReader();
return(myReader);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MySqlDataReader Search(SOReturnItemStatus SOReturnItemstatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID";
string SQL = SQLSelect() + "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 prmSOReturnItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16);
prmSOReturnItemStatus.Value = SOReturnItemstatus.ToString("d");
cmd.Parameters.Add(prmSOReturnItemStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
MySqlDataReader myReader = (MySqlDataReader) cmd.ExecuteReader();
return myReader;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MySqlDataReader List(SOReturnItemStatus SOReturnItemstatus, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "CreditMemoItemID";
string SQL = SQLSelect() + "WHERE ItemStatus = @ItemStatus " +
"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 prmSOReturnItemStatus = new MySqlParameter("@ItemStatus",MySqlDbType.Int16);
prmSOReturnItemStatus.Value = SOReturnItemstatus.ToString("d");
cmd.Parameters.Add(prmSOReturnItemStatus);
MySqlDataReader myReader = (MySqlDataReader) cmd.ExecuteReader();
return myReader;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
