public System.Data.DataTable ListAsDataTable(Int64 DebitMemoID = 0, DebitMemoItemStatus DebitMemoItemStatus = DebitMemoItemStatus.All, string SortField = "DebitMemoItemID", SortOption SortOrder = SortOption.Desscending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE 1=1 ";
if (DebitMemoID != 0)
{
SQL += "AND DebitMemoID = @DebitMemoID ";
cmd.Parameters.AddWithValue("DebitMemoID", DebitMemoID);
}
if (DebitMemoItemStatus != DebitMemoItemStatus.All)
{
SQL += "AND ItemStatus = @ItemStatus ";
cmd.Parameters.AddWithValue("@ItemStatus", DebitMemoItemStatus.ToString("d"));
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "DebitMemoItemID") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return(dt);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(Int64 DebitMemoID = 0, DebitMemoItemStatus DebitMemoItemStatus = DebitMemoItemStatus.All, string SortField = "DebitMemoItemID", SortOption SortOrder = SortOption.Desscending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE 1=1 ";
if (DebitMemoID != 0)
{
SQL += "AND DebitMemoID = @DebitMemoID ";
cmd.Parameters.AddWithValue("DebitMemoID", DebitMemoID);
}
if (DebitMemoItemStatus != DebitMemoItemStatus.All)
{
SQL += "AND ItemStatus = @ItemStatus ";
cmd.Parameters.AddWithValue("@ItemStatus", DebitMemoItemStatus.ToString("d"));
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "DebitMemoItemID") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
