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() + "分)
"; } } } 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() + "分)
"; } } } 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() + "分)
"; } } } 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() + "分)
"; } } } 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() + "分)
";
}
}
}
}
//写系统日志
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() + "";
}
}