private static ArrayList List(string lead, int comId, DateTime start, DateTime end, Pager pager) { /* SupplierBillingList @comId int=0, @leadGuid varchar(32)='', @start varchar(10)='', @end varchar(10)='', @pageIndex int=1, @pageSize int=20, @sort int=0 */ //[Id], CompanyId, LeadGuid, Amount, Remark, [Datetime] ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@comId",SqlDbType.Int,comId), Database.MakeInParam("@leadGuid",SqlDbType.VarChar,32,lead), Database.MakeInParam("@start",SqlDbType.VarChar,10,start==DateTime.MinValue?"":start.ToShortDateString()), Database.MakeInParam("@end",SqlDbType.VarChar,10,end==DateTime.MinValue?"":end.ToShortDateString()), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierBillingList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { SupplierBilling sb = new SupplierBilling(); sb.id = reader.GetInt32(0); sb.companyId = reader.GetInt32(1); sb.leadGuid = reader.GetString(2); sb.amount = Convert.ToSingle(reader.GetValue(3)); sb.remark = reader.GetString(4); sb.datetime = reader.GetDateTime(5); list.Add(sb); } } } reader.Close(); } catch { throw; } finally { if (reader != null) { reader.Close(); } } return list; }
public static SupplierBilling Get(int id) { SupplierBilling sb = new SupplierBilling(); return sb; }