//考场座位添加
public static long Add(Entity.MsSQL.T_ExamSeat model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_ExamSeat(");
strSql.Append("ExamRoomId,SeatNumber,TicketId)");
strSql.Append(" values (");
strSql.Append("@ExamRoomId,@SeatNumber,@TicketId)");
SqlParameter[] parameters =
{
new SqlParameter("@ExamRoomId", SqlDbType.VarChar, 50),
new SqlParameter("@SeatNumber", SqlDbType.VarChar, 50),
new SqlParameter("@TicketId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ExamRoomId;
parameters[1].Value = model.SeatNumber;
parameters[2].Value = model.TicketId;
object obj = Untity.HelperMsSQL.ExecuteScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
//查询考场座位
public static bool Select(Entity.MsSQL.T_ExamSeat model)
{
string sql = string.Format("select count(*) from T_ExamSeat where ExamRoomId='{0}' AND SeatNumber='{1}'", model.ExamRoomId, model.SeatNumber);
bool flag = Untity.HelperMsSQL.ExecuteQuerySelect(sql);
return(flag);
}
//（座位添加准考证）
public static bool Update(Entity.MsSQL.T_ExamSeat model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_ExamSeat set ");
strSql.Append("TicketId=@TicketId");
strSql.Append(" where ExamRoomId=@ExamRoomId AND SeatNumber=@SeatNumber ");
SqlParameter[] parameters =
{
new SqlParameter("@TicketId", SqlDbType.VarChar, 50),
new SqlParameter("@ExamRoomId", SqlDbType.VarChar, 50),
new SqlParameter("@SeatNumber", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.TicketId;
parameters[1].Value = model.ExamRoomId;
parameters[2].Value = model.SeatNumber;
int rows = Untity.HelperMsSQL.ExecuteQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//（座位添加准考证）
public static object updateexamseat(string _uid, string _pwd, string postString, ref string error)
{
Entity.MsSQL.T_Organiza _orga = Dal.MsSQL.T_Organiza.GetModel(_uid, _pwd);
if (_orga != null)
{
Entity.Request.addexamseat _examseat = Untity.HelperJson.DeserializeObject <Entity.Request.addexamseat>(postString);
Entity.MsSQL.T_ExamSeat _model = new Entity.MsSQL.T_ExamSeat()
{
ExamRoomId = Untity.HelperDataCvt.objToString(_examseat.ExamRoomId),
SeatNumber = Untity.HelperDataCvt.objToString(_examseat.SeatNumber),
TicketId = Untity.HelperDataCvt.objToString(_examseat.TicketId)
};
bool flag = Dal.MsSQL.T_ExamSeat.isSelect(_model);
if (flag)
{
error = "考场座位号已绑定，不能再次绑定！";
return("-1");
}
else
{
Dal.MsSQL.T_ExamSeat.Update(_model).ToString();
return("1");
}
}
else
{
error = "账号失效，请重新登陆";
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);
}
}
