private List SelectStocks(string sql, List paramList, SqlDataReader reader)
{
List list = new List();
while (reader.Read())
{
Stock stock = new Stock();
stock.ID = reader.GetInt32(0);
stock.Count = reader.GetInt32(1);
{
List
while (reader.Read())
{
Stock stock = new Stock();
stock.ID = reader.GetInt32(0);
stock.Count = reader.GetInt32(1);
stock.Storehouse = new Storehouse();
stock.Storehouse.ID = reader.GetInt32(2);
stock.Storehouse.Code = reader.GetString(3);
stock.Storehouse.Name = reader.GetString(4);
stock.Storehouse.Actived = reader.GetBoolean(5);
if (!reader.IsDBNull(6))
{
stock.Storehouse.Remark = reader.GetString(6);
}
stock.Storehouse.ID = reader.GetInt32(2);
stock.Storehouse.Code = reader.GetString(3);
stock.Storehouse.Name = reader.GetString(4);
stock.Storehouse.Actived = reader.GetBoolean(5);
if (!reader.IsDBNull(6))
{
stock.Storehouse.Remark = reader.GetString(6);
}
stock.Goods = new Goods();
stock.Goods.ID = reader.GetInt32(7);
stock.Goods.Code = reader.GetString(8);
stock.Goods.Name = reader.GetString(9);
stock.Goods.Actived = reader.GetBoolean(10);
if (!reader.IsDBNull(11))
{
stock.Goods.Remark = reader.GetString(11);
}
list.Add(stock);
}
reader.Close();
return list;
}
stock.Goods.ID = reader.GetInt32(7);
stock.Goods.Code = reader.GetString(8);
stock.Goods.Name = reader.GetString(9);
stock.Goods.Actived = reader.GetBoolean(10);
if (!reader.IsDBNull(11))
{
stock.Goods.Remark = reader.GetString(11);
}
list.Add(stock);
}
reader.Close();
return list;
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23109131/viewspace-665308/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
winform打开进程与关闭进程
下一篇：
创建XML
请登录后发表评论
登录
全部评论
