计算单元格值并插入记录 [英] Count cell values and insert record

问题描述

大家好，

我在sql表中有值，例如

Hi to all,

I have values in sql table like

RollNumber RoomNumber  RoomType    Status
---------------------------------------------
A101         1         Single      Booked
---------------------------------------------
A102         2         Single      Booked
---------------------------------------------
A103,A104    3         TwoSeater   Booked
---------------------------------------------
A105         4         TwoSeater   Available
---------------------------------------------
A106,A107    3         FourSeater  Available
---------------------------------------------
A105         4         FourSeater  Available
---------------------------------------------

现在，我需要获取计数，其中roomtype = twoseater.
然后，如果已经填写了卷号(A103，A104)，则状态将显示为已预订.
现在，如果填写了卷号(A105)，但我需要为两个座位(RoomType)插入另一个卷号，则该状态将显示为可用.

以上这些操作我需要使用c#在asp.net中进行.

谁能帮我.

对不起，普通英语

在此先感谢............

[edit]已添加代码块-OriginalGriff [/edit]

Now i need get count of rollnumber where roomtype= twoseater.
Then if already roll numbers (A103,A104) filled ,then status will show Booked.
Now if roll number (A105) filled but i need to insert another one rollnumber for two seater(RoomType), that status will show available.

these above operation i need to do in asp.net using c#.

Can anyone help me.

Sorry for average english

Thanks in advance............

[edit]Code block added - OriginalGriff[/edit]

推荐答案

返回"TwoSeater"类中的房间数:

To return the number of rooms in the class "TwoSeater":

SELECT COUNT(RollNumber) FROM myTable WHERE RoomType='TwoSeater'

就个人而言，我不会将房间类别存储为描述，而是存储整数形式的席位".这样，您可以通过返回可用类型的顶部结果，并且座位> =所需座位数(由座位"按升序排列)来进行数学运算，以达到结果.

Personally, I would not store the room class as a description, but store an Integer number of "Seats" instead. That way, you can do math to achieve your result, by returning the top result where type is available, and seats >= number-of-seats-required, ordered by "Seats" in ascending order.

这篇关于计算单元格值并插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！