using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class DocFile_TiKuKaoShiView : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPTiKuKaoShi Modela = new ZWL.BLL.ERPTiKuKaoShi(); Modela.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.lblUserName.Text=Modela.UserName.ToString(); this.lblTimeStr.Text=Modela.TimeStr.ToString(); this.lblShiJuanName.Text=Modela.ShiJuanName.ToString(); //读取试卷信息 ZWL.BLL.ERPTiKuShiJuan Model = new ZWL.BLL.ERPTiKuShiJuan(); Model.GetModel(int.Parse(Modela.ShiJuanID.ToString())); string[] FenLeiSunXu = Model.FenLeiShunXu.Split('|'); for (int j = 0; j < FenLeiSunXu.Length; j++) { string DaBiaoTi = "一"; if (j == 0) { DaBiaoTi = "一"; } else if (j == 1) { DaBiaoTi = "二"; } else if (j == 2) { DaBiaoTi = "三"; } else if (j == 3) { DaBiaoTi = "四"; } else if (j == 4) { DaBiaoTi = "五"; } //绑定当前题目已有的题目 string TiMuIDList = "0"; if (FenLeiSunXu[j].ToString() == "判断题") { TiMuIDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select TiMuID from ERPTiKuKaoShiJieGuo where TiMuID in (select ID from ERPTiKu where FenLeiStr='" + FenLeiSunXu[j].ToString() + "') and KaoShiID=" + Request.QueryString["ID"].ToString()).Replace('|', ','); if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0") { //一、 判断题(每题1分,共20分) this.Label1.Text = this.Label1.Text + DaBiaoTi + "、" + FenLeiSunXu[j].ToString() + "(每题" + Model.PanDuanFenShu.ToString() + "分,共" + TiMuIDList.Split(',').Length.ToString() + "题,合计" + (Model.PanDuanFenShu * TiMuIDList.Split(',').Length).ToString() + "分)
"; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')"); for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++) { int TempNum = i + 1; this.Label1.Text = this.Label1.Text + TempNum.ToString() + ":" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "" + JieDaStr(MYDT.Tables[0].Rows[i]["ID"].ToString(), Request.QueryString["ID"].ToString()) + "
"; if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   A:" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   B:" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "
"; } this.Label1.Text = this.Label1.Text + "

"; } } } else if (FenLeiSunXu[j].ToString() == "单项选择题") { TiMuIDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select TiMuID from ERPTiKuKaoShiJieGuo where TiMuID in (select ID from ERPTiKu where FenLeiStr='" + FenLeiSunXu[j].ToString() + "') and KaoShiID=" + Request.QueryString["ID"].ToString()).Replace('|', ','); if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0") { this.Label1.Text = this.Label1.Text + DaBiaoTi + "、" + FenLeiSunXu[j].ToString() + "(每题" + Model.DanXuanFenShu.ToString() + "分,共" + TiMuIDList.Split(',').Length.ToString() + "题,合计" + (Model.DanXuanFenShu * TiMuIDList.Split(',').Length).ToString() + "分)


"; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')"); for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++) { int TempNum = i + 1; this.Label1.Text = this.Label1.Text + TempNum.ToString() + ":" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "" + JieDaStr(MYDT.Tables[0].Rows[i]["ID"].ToString(), Request.QueryString["ID"].ToString()) + "
"; if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   A:" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   B:" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsC"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   C:" + MYDT.Tables[0].Rows[i]["ItemsC"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsD"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   D:" + MYDT.Tables[0].Rows[i]["ItemsD"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsE"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   E:" + MYDT.Tables[0].Rows[i]["ItemsE"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsF"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   F:" + MYDT.Tables[0].Rows[i]["ItemsF"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsG"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   G:" + MYDT.Tables[0].Rows[i]["ItemsG"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsH"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   H:" + MYDT.Tables[0].Rows[i]["ItemsH"].ToString() + "
"; } this.Label1.Text = this.Label1.Text + "

"; } } } else if (FenLeiSunXu[j].ToString() == "多项选择题") { TiMuIDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select TiMuID from ERPTiKuKaoShiJieGuo where TiMuID in (select ID from ERPTiKu where FenLeiStr='" + FenLeiSunXu[j].ToString() + "') and KaoShiID=" + Request.QueryString["ID"].ToString()).Replace('|', ','); if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0") { this.Label1.Text = this.Label1.Text + DaBiaoTi + "、" + FenLeiSunXu[j].ToString() + "(每题" + Model.DuoXuanFenShu.ToString() + "分,共" + TiMuIDList.Split(',').Length.ToString() + "题,合计" + (Model.DuoXuanFenShu * TiMuIDList.Split(',').Length).ToString() + "分)


"; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')"); for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++) { int TempNum = i + 1; this.Label1.Text = this.Label1.Text + TempNum.ToString() + ":" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "" + JieDaStr(MYDT.Tables[0].Rows[i]["ID"].ToString(), Request.QueryString["ID"].ToString()) + "
"; if (MYDT.Tables[0].Rows[i]["ItemsA"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   A:" + MYDT.Tables[0].Rows[i]["ItemsA"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsB"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   B:" + MYDT.Tables[0].Rows[i]["ItemsB"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsC"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   C:" + MYDT.Tables[0].Rows[i]["ItemsC"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsD"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   D:" + MYDT.Tables[0].Rows[i]["ItemsD"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsE"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   E:" + MYDT.Tables[0].Rows[i]["ItemsE"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsF"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   F:" + MYDT.Tables[0].Rows[i]["ItemsF"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsG"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   G:" + MYDT.Tables[0].Rows[i]["ItemsG"].ToString() + "
"; } if (MYDT.Tables[0].Rows[i]["ItemsH"].ToString().Trim().Length > 0) { this.Label1.Text = this.Label1.Text + "   H:" + MYDT.Tables[0].Rows[i]["ItemsH"].ToString() + "
"; } this.Label1.Text = this.Label1.Text + "

"; } } } else if (FenLeiSunXu[j].ToString() == "填空题") { TiMuIDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select TiMuID from ERPTiKuKaoShiJieGuo where TiMuID in (select ID from ERPTiKu where FenLeiStr='" + FenLeiSunXu[j].ToString() + "') and KaoShiID=" + Request.QueryString["ID"].ToString()).Replace('|', ','); if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0") { this.Label1.Text = this.Label1.Text + DaBiaoTi + "、" + FenLeiSunXu[j].ToString() + "(每题" + Model.TianKongFenShu.ToString() + "分,共" + TiMuIDList.Split(',').Length.ToString() + "题,合计" + (Model.TianKongFenShu * TiMuIDList.Split(',').Length).ToString() + "分)


"; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')"); for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++) { int TempNum = i + 1; this.Label1.Text = this.Label1.Text + TempNum.ToString() + ":" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "" + JieDaStr2(MYDT.Tables[0].Rows[i]["ID"].ToString(), Request.QueryString["ID"].ToString()) + "
"; this.Label1.Text = this.Label1.Text + "

"; } } } else if (FenLeiSunXu[j].ToString() == "简答题") { TiMuIDList = ZWL.DBUtility.DbHelperSQL.GetStringList("select TiMuID from ERPTiKuKaoShiJieGuo where TiMuID in (select ID from ERPTiKu where FenLeiStr='" + FenLeiSunXu[j].ToString() + "') and KaoShiID=" + Request.QueryString["ID"].ToString()).Replace('|', ','); if (TiMuIDList.Trim().Length > 0 && TiMuIDList.Trim() != "0") { this.Label1.Text = this.Label1.Text + DaBiaoTi + "、" + FenLeiSunXu[j].ToString() + "(每题" + Model.JianDaFenShu.ToString() + "分,共" + TiMuIDList.Split(',').Length.ToString() + "题,合计" + (Model.JianDaFenShu * TiMuIDList.Split(',').Length).ToString() + "分)


"; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTiKu where ID in('" + TiMuIDList.Replace(",", "','") + "')"); for (int i = 0; i < MYDT.Tables[0].Rows.Count; i++) { int TempNum = i + 1; this.Label1.Text = this.Label1.Text + TempNum.ToString() + ":" + MYDT.Tables[0].Rows[i]["TitleStr"].ToString() + "" + JieDaStr2(MYDT.Tables[0].Rows[i]["ID"].ToString(), Request.QueryString["ID"].ToString()) + "
"; this.Label1.Text = this.Label1.Text + "

"; } } } } //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看在线考试信息(" + this.lblUserName.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); } } public string JieDaStr2(string TiMuIDStr,string KaoShiIDStr) { string DaAnStr = ""; string UserDaAn = ""; string DeFenStr = ""; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select top 1 * from ERPTiKuKaoShiJieGuo where KaoShiID=" + KaoShiIDStr + " and TiMuID=" + TiMuIDStr); if (MYDT.Tables[0].Rows.Count > 0) { DaAnStr = MYDT.Tables[0].Rows[0]["DaAn"].ToString(); UserDaAn = MYDT.Tables[0].Rows[0]["UserDaAn"].ToString(); DeFenStr = MYDT.Tables[0].Rows[0]["DeFen"].ToString(); } return "
   本题标准答案:" + DaAnStr + "
   用户答案:" + UserDaAn + "
   得分:" + DeFenStr.ToString()+"
"; } public string JieDaStr(string TiMuIDStr, string KaoShiIDStr) { string DaAnStr = ""; string UserDaAn = ""; string DeFenStr = ""; DataSet MYDT = ZWL.DBUtility.DbHelperSQL.GetDataSet("select top 1 * from ERPTiKuKaoShiJieGuo where KaoShiID=" + KaoShiIDStr + " and TiMuID=" + TiMuIDStr); if (MYDT.Tables[0].Rows.Count > 0) { DaAnStr = MYDT.Tables[0].Rows[0]["DaAn"].ToString(); UserDaAn = MYDT.Tables[0].Rows[0]["UserDaAn"].ToString(); DeFenStr = MYDT.Tables[0].Rows[0]["DeFen"].ToString(); } return "
   本题标准答案:" + DaAnStr + "   用户答案:" + UserDaAn + "   得分:" + DeFenStr.ToString() + "
"; } }