/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(kaoshiModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into kaoshi(");
strSql.Append("nc_kaoshiId,nc_qid,nc_daanid,bit_isRight,nc_uid)");
strSql.Append(" values (");
strSql.Append("@nc_kaoshiId,@nc_qid,@nc_daanid,@bit_isRight,@nc_uid)");
SqlParameter[] parameters = {
new SqlParameter("@nc_kaoshiId", SqlDbType.NChar,18),
new SqlParameter("@nc_qid", SqlDbType.NChar,10),
new SqlParameter("@nc_daanid", SqlDbType.NChar,12),
new SqlParameter("@bit_isRight", SqlDbType.Bit,1),
new SqlParameter("@nc_uid", SqlDbType.NChar,20)};
parameters[0].Value = model.nc_kaoshiId;
parameters[1].Value = model.nc_qid;
parameters[2].Value = model.nc_daanid;
parameters[3].Value = model.bit_isRight;
parameters[4].Value = model.nc_uid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public kaoshiModel DataRowToModel(DataRow row)
{
kaoshiModel model = new kaoshiModel();
if (row != null)
{
if (row["nc_id"] != null)
{
model.nc_id = row["nc_id"].ToString();
}
if (row["nc_kaoshiId"] != null)
{
model.nc_kaoshiId = row["nc_kaoshiId"].ToString();
}
if (row["nc_qid"] != null)
{
model.nc_qid = row["nc_qid"].ToString();
}
if (row["nc_daanid"] != null)
{
model.nc_daanid = row["nc_daanid"].ToString();
}
if (row["bit_isRight"] != null && row["bit_isRight"].ToString() != "")
{
if ((row["bit_isRight"].ToString() == "1") || (row["bit_isRight"].ToString().ToLower() == "true"))
{
model.bit_isRight = true;
}
else
{
model.bit_isRight = false;
}
}
if (row["nvc_chengji"] != null)
{
model.nvc_chengji = row["nvc_chengji"].ToString();
}
if (row["dt_shijian"] != null && row["dt_shijian"].ToString() != "")
{
model.dt_shijian = DateTime.Parse(row["dt_shijian"].ToString());
}
if (row["nc_uid"] != null)
{
model.nc_uid = row["nc_uid"].ToString();
}
}
return model;
}
protected void Page_Load(object sender, EventArgs e)
{
string uid = new SetCookie().WhetherOnline();
if (!string.IsNullOrEmpty(uid))
{
int rightTimu = 0;
#region 获取考试ID，总题数
string kaoshiId = null;
if (!string.IsNullOrEmpty(Request.Form["kaoshiId"]))//获取数据类型
{
kaoshiId = Request.Form["kaoshiId"];
}
int totalTimu = 0;
if (!string.IsNullOrEmpty(Request.Form["totalTimu"]))//获取数据类型
{
totalTimu = int.Parse(Request.Form["totalTimu"]);
}
#endregion
bool isok = false;
for (int i = 1; i <= totalTimu; i++)
{
#region 获取数据
string timuid = null;
if (!string.IsNullOrEmpty(Request.Form["tihao" + i]))//获取数据类型
{
timuid = Request.Form["tihao" + i];
}
string daanid = null;
if (!string.IsNullOrEmpty(Request.Form["timudaan" + i]))//获取数据类型
{
daanid = Request.Form["timudaan" + i];
}
bool isRight = false;
if (!string.IsNullOrEmpty(Request.Form["isRight" + i]))//获取数据类型
{
string ir = Request.Form["isRight" + i];
if (ir == "1")
{
isRight = true;
rightTimu++;
}
else
{
isRight = false;
}
}
#endregion
#region 提交数据
questionModel qm = new questionDAL().GetModel(timuid);
//单选，判断
if (qm.int_qtype == 1 || qm.int_qtype == 0)
{
kaoshiModel ksm = new kaoshiModel();
ksm.nc_kaoshiId = kaoshiId;
ksm.nc_qid = timuid;
ksm.nc_daanid = daanid;
ksm.bit_isRight = isRight;
ksm.nc_uid = uid;
isok = new kaoshiDAL().Add(ksm);
}
//多选
if (qm.int_qtype == 2)
{
kaoshiModel ksm = new kaoshiModel();
ksm.nc_kaoshiId = kaoshiId;
ksm.nc_qid = timuid;
ksm.bit_isRight = isRight;
ksm.nc_uid = uid;
if (string.IsNullOrEmpty(daanid))
{
isok = new kaoshiDAL().Add(ksm);
}
else
{
daanid = daanid.Substring(0, daanid.Length - 1);
string[] arrayList = daanid.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string opid in arrayList)
{
ksm.nc_daanid = opid;
isok = new kaoshiDAL().Add(ksm);
}
}
}
#endregion
}
#region 更改部分数据
bool isupdatechengji = new kaoshiDAL().UpDateChengji(kaoshiId, rightTimu.ToString());
bool isupdateShijian = new kaoshiDAL().UpDateShijian(kaoshiId);
#endregion
Response.Write("<script>javascript:if(window.confirm('交卷成功，考试成绩为" + rightTimu.ToString() + "分！是否重新考试？') == true){window.location.replace('kaoshi.aspx');}</script>");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(kaoshiModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update kaoshi set ");
strSql.Append("nc_kaoshiId=@nc_kaoshiId,");
strSql.Append("nc_qid=@nc_qid,");
strSql.Append("nc_daanid=@nc_daanid,");
strSql.Append("bit_isRight=@bit_isRight,");
strSql.Append("nvc_chengji=@nvc_chengji,");
strSql.Append("dt_shijian=@dt_shijian,");
strSql.Append("nc_uid=@nc_uid");
strSql.Append(" where nc_id=@nc_id ");
SqlParameter[] parameters = {
new SqlParameter("@nc_kaoshiId", SqlDbType.NChar,18),
new SqlParameter("@nc_qid", SqlDbType.NChar,10),
new SqlParameter("@nc_daanid", SqlDbType.NChar,12),
new SqlParameter("@bit_isRight", SqlDbType.Bit,1),
new SqlParameter("@nvc_chengji", SqlDbType.NVarChar,50),
new SqlParameter("@dt_shijian", SqlDbType.DateTime),
new SqlParameter("@nc_uid", SqlDbType.NChar,20),
new SqlParameter("@nc_id", SqlDbType.NChar,20)};
parameters[0].Value = model.nc_kaoshiId;
parameters[1].Value = model.nc_qid;
parameters[2].Value = model.nc_daanid;
parameters[3].Value = model.bit_isRight;
parameters[4].Value = model.nvc_chengji;
parameters[5].Value = model.dt_shijian;
parameters[6].Value = model.nc_uid;
parameters[7].Value = model.nc_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public kaoshiModel GetModel(string nc_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 nc_id,nc_kaoshiId,nc_qid,nc_daanid,bit_isRight,nvc_chengji,dt_shijian,nc_uid from kaoshi ");
strSql.Append(" where nc_id=@nc_id ");
SqlParameter[] parameters = {
new SqlParameter("@nc_id", SqlDbType.NChar,20) };
parameters[0].Value = nc_id;
kaoshiModel model = new kaoshiModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}