//public static VendorBalance FindVendorBalance(MySql.Data.MySqlClient.MySqlCommand cmd, long periodId)
//{
// cmd.CommandText = String.Format("select * from table_vendorbalance where period_id = {0}", periodId);
// MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
// VendorBalance sc = VendorBalance.TransformReader(r);
// r.Close();
// return sc;
//}
public static IList FindVendorBalanceByPeriod(MySql.Data.MySqlClient.MySqlCommand cmd, long periodId)
{
cmd.CommandText = String.Format("select * from table_vendorbalance where period_id = {0}", periodId);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
IList sc = VendorBalance.TransformReaderList(r);
r.Close();
return(sc);
}
public IList GetVendorBalances(int supID)
{
ArrayList result = new ArrayList();
OpenConnection();
MySql.Data.MySqlClient.MySqlDataReader r;
m_cmd.CommandText = VendorBalance.FindByVendorBalanceByCustomer(supID);
r = m_cmd.ExecuteReader();
IList vbe = VendorBalance.TransformReaderList(r);
r.Close();
foreach (VendorBalance v in vbe)
{
result.Add(v);
}
result.Sort(new VendorBalanceComparer());
return(result);
}
