//考场座位添加 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); } }