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