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