public static IncomeCollection Get(int uid, int comId) { /*INV_IncomeCollectionGet @uid int, @comId int */ IncomeCollection ic = null; using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_IncomeCollectionGet", new SqlParameter[] { Database.MakeInParam("@uid",SqlDbType.Int,uid), Database.MakeInParam("@comId",SqlDbType.Int,comId) })) { if (reader.Read()) { ic = new IncomeCollection(); ic.companyId = reader.GetInt32(0); ic.userId = reader.GetInt32(1); ic.companyName = reader.IsDBNull(2) ? "" : reader.GetString(2); ic.companyEmail = reader.IsDBNull(3) ? "" : reader.GetString(3); ic.sum = Convert.ToSingle(reader.GetValue(4)); } reader.Close(); } return ic; }
public static List<IncomeCollection> List(int uid, Pager pager) { /* INV_IncomeCollectionList @uid int, @pageIndex int=1, @pageSize int=20, @sort int=0 */ //CompanyId,UserId,CompanyName,CompanyEmail,Amount List<IncomeCollection> list = new List<IncomeCollection>(); using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_IncomeCollectionList", new SqlParameter[] { Database.MakeInParam("@uid",SqlDbType.Int,uid), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum) })) { if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { IncomeCollection ic; while (reader.Read()) { ic = new IncomeCollection(); ic.companyId = reader.GetInt32(0); ic.userId = reader.GetInt32(1); ic.companyName = reader.IsDBNull(2) ? "" : reader.GetString(2); ic.companyEmail = reader.IsDBNull(3) ? "" : reader.GetString(3); ic.sum = Convert.ToSingle(reader.GetValue(4)); list.Add(ic); } } } reader.Close(); } return list; }