//判断是否绑定座位
public static object isbountseat(string _uid, string _pwd, string _ticketnum, ref string error)
{
Entity.Respose.getexamseatInfo result = new Entity.Respose.getexamseatInfo();
Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd);
bool flag = Dal.MsSQL.T_ExamSeat.isSelectSeat(_ticketnum);
if (flag)
{
return("0");
}
return("-1");
}
public static bool isSelect(Entity.MsSQL.T_ExamSeat model)
{
bool flag = false;
string sql = string.Format("SELECT id, ExamRoomId , SeatNumber,TicketId" +
" FROM T_ExamSeat where ExamRoomId = '{0}' AND SeatNumber = '{1}'", model.ExamRoomId, model.SeatNumber);
List <Entity.Respose.getexamseatInfo> list = Untity.HelperMsSQL.ExecuteQueryToList <Entity.Respose.getexamseatInfo>(sql);
if (list == null || list.Count == 0)
{
return(flag);
}
else
{
Entity.Respose.getexamseatInfo result = list.FirstOrDefault();
if (result.TicketId != "")
{
flag = true;
return(flag);
}
return(flag);
}
}
