//修改考场 public static object updateexamroom(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.addexamroom _examroom = Untity.HelperJson.DeserializeObject <Entity.Request.addexamroom>(postString); Entity.MsSQL.T_ExamRoom _model = new Entity.MsSQL.T_ExamRoom() { Id = _examroom.id, ExamName = Untity.HelperDataCvt.objToString(_examroom.ExamName), ExamPlace = Untity.HelperDataCvt.objToString(_examroom.ExamPlace), CentreName = Untity.HelperDataCvt.objToString(_examroom.CentreName), ExamNum = Untity.HelperDataCvt.objToString(_examroom.ExamNum), SeatNum = Untity.HelperDataCvt.objToString(_examroom.SeatNum), ResultReleaseTime = _examroom.ResultReleaseTime }; Dal.MsSQL.T_ExamRoom.Update(_model, postString).ToString(); return("1"); } else { error = "账号失效,请重新登陆"; return("-1"); } }
//添加考场 public static long Add(Entity.MsSQL.T_ExamRoom model, string postString) { string sql = string.Format("insert into T_ExamRoom(ExamName,ExamPlace,CentreName,ExamNum,SeatNum,ResultReleaseTime,createtime,IsDel)values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');select @@identity", model.ExamName, model.ExamPlace, model.CentreName, model.ExamNum, model.SeatNum, model.ResultReleaseTime, model.CreateTime, model.IsDel); string ExamRoomId = Untity.HelperMsSQL.ExecuteQueryExam(sql).ToString(); if (ExamRoomId != "" && ExamRoomId != null) { JArray Seats = JArray.Parse(JObject.Parse(postString)["detal"].ToString()); StringBuilder SeatSQL = new StringBuilder(); SeatSQL.Append("insert into T_ExamSeat("); SeatSQL.Append("ExamRoomId,SeatNumber,TicketId)"); SeatSQL.Append(" values ("); SeatSQL.Append("@ExamRoomId,@SeatNumber,@TicketId)"); for (int i = 0; i < Seats.Count; i++) { SqlParameter[] parametersSeat = { new SqlParameter("@ExamRoomId", SqlDbType.VarChar, 50), new SqlParameter("@SeatNumber", SqlDbType.VarChar, 50), new SqlParameter("@TicketId", SqlDbType.VarChar, 50) }; parametersSeat[0].Value = ExamRoomId; parametersSeat[1].Value = Seats[i]["SeatNumber"]; parametersSeat[2].Value = ""; object objSeat = Untity.HelperMsSQL.ExecuteScalar(SeatSQL.ToString(), parametersSeat); if (objSeat != null) { return(Convert.ToInt64(objSeat)); } } return(0); } else { return(Convert.ToInt64(-1)); } }
//修改考场 public static bool Update(Entity.MsSQL.T_ExamRoom model, string postString) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_ExamRoom set "); strSql.Append("ExamName=@ExamName,"); strSql.Append("ExamPlace=@ExamPlace,"); strSql.Append("CentreName=@CentreName,"); strSql.Append("ExamNum=@ExamNum,"); strSql.Append("SeatNum=@SeatNum,"); strSql.Append("ResultReleaseTime=@ResultReleaseTime,"); strSql.Append("createtime=@createtime,"); strSql.Append("IsDel=@IsDel"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@ExamName", SqlDbType.VarChar, 50), new SqlParameter("@ExamPlace", SqlDbType.VarChar, 50), new SqlParameter("@CentreName", SqlDbType.VarChar, 50), new SqlParameter("@ExamNum", SqlDbType.VarChar, 50), new SqlParameter("@SeatNum", SqlDbType.VarChar, 50), new SqlParameter("@ResultReleaseTime", SqlDbType.DateTime), new SqlParameter("@createtime", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.Char, 1), new SqlParameter("@Id", SqlDbType.Int, 100) }; parameters[0].Value = model.ExamName; parameters[1].Value = model.ExamPlace; parameters[2].Value = model.CentreName; parameters[3].Value = model.ExamNum; parameters[4].Value = model.SeatNum; parameters[5].Value = model.ResultReleaseTime; parameters[6].Value = model.CreateTime; parameters[7].Value = model.IsDel; parameters[8].Value = model.Id; int rows = Untity.HelperMsSQL.ExecuteQuery(strSql.ToString(), parameters); if (rows > 0) { JArray Seats = JArray.Parse(JObject.Parse(postString)["detal"].ToString()); StringBuilder SeatSQL = new StringBuilder(); SeatSQL.Append("insert into T_ExamSeat("); SeatSQL.Append("ExamRoomId,SeatNumber,TicketId)"); SeatSQL.Append(" values ("); SeatSQL.Append("@ExamRoomId,@SeatNumber,@TicketId)"); for (int i = 0; i < Seats.Count; i++) { string sql = string.Format("select count(*) from T_ExamSeat where ExamRoomId='{0}' AND SeatNumber='{1}'", JObject.Parse(postString)["Id"].ToString(), Seats[i]["SeatNumber"]); bool flag = Untity.HelperMsSQL.ExecuteQuerySelect(sql); if (!flag) { SqlParameter[] parametersSeat = { new SqlParameter("@ExamRoomId", SqlDbType.VarChar, 50), new SqlParameter("@SeatNumber", SqlDbType.VarChar, 50), new SqlParameter("@TicketId", SqlDbType.VarChar, 50) }; parametersSeat[0].Value = JObject.Parse(postString)["Id"].ToString(); parametersSeat[1].Value = Seats[i]["SeatNumber"]; parametersSeat[2].Value = ""; object objSeat = Untity.HelperMsSQL.ExecuteScalar(SeatSQL.ToString(), parametersSeat); if (objSeat != null) { return(false); } } } if (JObject.Parse(postString)["del"] != null) { JArray DelSeats = JArray.Parse(JObject.Parse(postString)["del"].ToString()); StringBuilder DelSeatSQL = new StringBuilder(); DelSeatSQL.Append("delete from T_ExamSeat"); DelSeatSQL.Append(" where id = @Id"); for (int k = 0; k < DelSeats.Count; k++) { SqlParameter[] parametersSeat = { new SqlParameter("@Id", SqlDbType.VarChar, 50) }; parametersSeat[0].Value = DelSeats[k]["Id"]; object objSeat = Untity.HelperMsSQL.ExecuteScalar(DelSeatSQL.ToString(), parametersSeat); if (objSeat != null) { return(false); } } } return(true); } else { return(false); } }
//查询考场通过id获得 public static object getexamroombyid(string _uid, string _pwd, string id, ref string error) { Entity.MsSQL.T_ExamRoom result = Dal.MsSQL.T_ExamRoom.GetRomByid(id); return(result); }