public bool IsHasSeat(TextBlock room, string sno, out int seatno)
{
seatno = -1;
string sql = "select seat_no from tb_seat_student where no='" + sno + "' and isoutdate=0;";
SqlParameter[] sp = { };
var res = SqlServerHelper.ExecuteSclar(sql, sp);
if (res != null)
{
seatno = (int)res;
}
return(res != null);
}
internal string FindNo(string str)
{
string sql = "select no from tb_student where card='" + str + "'";
return((string)SqlServerHelper.ExecuteSclar(sql));
}