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