我想把LISTVIEW里面每一列里面的数值都统计下,
#region private void AllSumRoom() 房间数合计
/// <summary>
/// 房间数合计
/// </summary>
private void AllSumRoom()
{
DataSet myDataSet=new DataSet();
IBaseBlock myblock = BlockFactory.Creator();
myblock.Open();
myblock.Fill(myDataSet,"SELECT * FROM Rooms join CompaniesRooms on Rooms.RoomID = CompaniesRooms.RoomID and CompaniesRooms.CompanyID="+comboCompanyName.SelectedValue.ToString() +" order by Rooms.roomid","CompaniesRooms");
myblock.Close();
}
#endregion
这个是房间数的合计~~
但是住入人数是有不同,要统计的是所有 把可容纳人数和已入住人数分别再统计下 帮下我这个菜鸟吧~~~
谢谢
房间号 可容纳 已住
2101 8 0 0
2102 8 0 0
2103 8 0 0
2104 8 0 0
2105 8 0 0
2106 8 0 0
2107 8 0 0
2108 8 0 0
2109 8 0 0
2110 8 0 0
8101 8 6 0
8103 2 3 0
8104 2 2 0
8105 2 1 0
8107 2 0 0
8109 2 1 0
8111 2 1 0
8113 2 1 0
#region private void AllSumRoom() 房间数合计
/// <summary>
/// 房间数合计
/// </summary>
private void AllSumRoom()
{
DataSet myDataSet=new DataSet();
IBaseBlock myblock = BlockFactory.Creator();
myblock.Open();
myblock.Fill(myDataSet,"SELECT * FROM Rooms join CompaniesRooms on Rooms.RoomID = CompaniesRooms.RoomID and CompaniesRooms.CompanyID="+comboCompanyName.SelectedValue.ToString() +" order by Rooms.roomid","CompaniesRooms");
myblock.Close();
}
#endregion
这个是房间数的合计~~
但是住入人数是有不同,要统计的是所有 把可容纳人数和已入住人数分别再统计下 帮下我这个菜鸟吧~~~
谢谢
房间号 可容纳 已住
2101 8 0 0
2102 8 0 0
2103 8 0 0
2104 8 0 0
2105 8 0 0
2106 8 0 0
2107 8 0 0
2108 8 0 0
2109 8 0 0
2110 8 0 0
8101 8 6 0
8103 2 3 0
8104 2 2 0
8105 2 1 0
8107 2 0 0
8109 2 1 0
8111 2 1 0
8113 2 1 0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货