//修改考场
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);
}
