/// <summary> /// 获取填空题答案 /// </summary> /// <param name="PapersID"></param> /// <param name="titleID"></param> /// <returns></returns> public string GetGapAnswer(int PapersID, int titleID) { BLL.Results BResults = new BLL.Results(); string strSql = "SELECT UserID,PapersID,TitleListID,Answer FROM [Results] where PapersID=@PapersID and TitleListID=@titleID and UserID=@userID"; SqlParameter[] parames = { new SqlParameter("@PapersID", SqlDbType.Int, 4), new SqlParameter("@titleID", SqlDbType.Int, 4), new SqlParameter("@userID", SqlDbType.Int, 4), }; parames[0].Value = PapersID; parames[1].Value = titleID; parames[2].Value = Convert.ToInt32(Request.QueryString["companyID"]); DataTable dtResult = BResults.ExecSQL(strSql, parames); if (dtResult.Rows.Count > 0) { return(dtResult.Rows[0]["Answer"].ToString()); } else { return(""); } }
/// <summary> /// 获取已选题目 /// </summary> /// <returns></returns> public int GetselOption(int int_paperID, int int_titleID) { BLL.Results BResults = new BLL.Results(); string strSql = "SELECT UserID,PapersID,TitleListID,Answer FROM [Results] where PapersID=@PapersID and TitleListID=@TitleListID and UserID=@UserID"; SqlParameter[] parames = { new SqlParameter("@PapersID", SqlDbType.Int, 4), new SqlParameter("@TitleListID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), }; parames[0].Value = int_paperID; parames[1].Value = int_titleID; parames[2].Value = Convert.ToInt32(Request.QueryString["companyID"]); DataTable dtResult = BResults.ExecSQL(strSql, parames); if (dtResult.Rows.Count > 0) { //return int.Parse(dtResult.Rows[0]["Answer"].ToString()); if (dtResult.Rows[0]["Answer"].ToString() == "") { return(0); } else { return(int.Parse(dtResult.Rows[0]["Answer"].ToString())); } } return(0); }
/// <summary> /// 提交答案 /// </summary> /// <param name="Type">类型(单选/多选/不定项选/判断)</param> /// <param name="PapersID">试卷ID</param> /// <param name="gv">GridView</param> private void Submit(string Type, int PapersID, GridView gv, string Time) { BLL.PapersTitleList bll = new BLL.PapersTitleList(); if (bll.nGetList(Type, PapersID)) { for (int i = 0; i < gv.Rows.Count; i++) { Label lb = (Label)gv.Rows[i].FindControl("lb_ID"); int TitleListID = int.Parse(lb.Text); string Str_radio = Request.Form["radio" + TitleListID]; //Response.Write(Type + "题目:" + TitleListID + " 答案:" + Str_radio + "<br/>"); BLL.Results bll1 = new BLL.Results(); Model.Results model = new Model.Results(); model.UserID = int.Parse(lb_U.Text); model.PapersID = PapersID; model.TitleListID = TitleListID; model.Answer = Str_radio; model.Time = Time; //Common.Function.Alert(model.UserID.ToString()); //bll1.Add(model); } } else { } }
private void gv01_Bind(int UserID, int PapersID, string Time) { BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); list = bll.Details(UserID, PapersID, Time); gv01.DataSource = list; gv01.DataBind(); }
private void gv01_Bind1(int CourseID) { BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); if (ViewState["PageCount"] == null) { ViewState["PageCount"] = 1; } list = bll.GetList(CourseID); gv01.DataSource = list; gv01.DataBind(); }
private void gv01_Bind1(string Time) { BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); Time = Time[0].ToString() + Time[1].ToString() + Time[2].ToString() + Time[3].ToString() + "-" + Time[4].ToString() + Time[5].ToString() + "-" + Time[6].ToString() + Time[7].ToString(); if (ViewState["PageCount"] == null) { ViewState["PageCount"] = 1; } list = bll.GetList(Time); gv01.DataSource = list; gv01.DataBind(); }
private void Auto() { int UserID; int PapersID; string Time; for (int i = 0; i < gv01.Rows.Count; i++) { Label lb_UserID = (Label)gv01.Rows[i].FindControl("lb_UserID"); Label lb_PapersID = (Label)gv01.Rows[i].FindControl("lb_PapersID"); Label lb_Time = (Label)gv01.Rows[i].FindControl("lb_Time"); UserID = int.Parse(lb_UserID.Text); PapersID = int.Parse(lb_PapersID.Text); Time = lb_Time.Text; BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); list = bll.Details(UserID, PapersID, Time); } if (Request.QueryString["CourseID"] != null) { CourseBind(); div_Course.Visible = true; gv01_Bind1(int.Parse(Request.QueryString["CourseID"].ToString())); } else { if (Request.QueryString["UserID"] != null) { gv01_BindUserID1(int.Parse(Request.QueryString["UserID"].ToString())); } else { gv01_Bind1(Request.QueryString["Time"]); } } }
private void gv01_Bind() { BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); if (ViewState["PageCount"] == null) { ViewState["PageCount"] = 1; } string Sort = ViewState["SortOrder"].ToString() + " " + ViewState["OrderDire"].ToString(); if (CourseID > 0) { list = bll.GetList(CourseID); } else { //list = bll.GetList(); list = bll.GetList(Convert.ToInt32(ViewState["PageCount"]), PageSize, Sort, tb_Search.Text.Trim(), ddl_Search.SelectedValue); } gv01.DataSource = list; gv01.DataBind(); if (list.Count > 0) { Total = list[0].RowTotal; labAlert.Visible = false; } else { labAlert.Visible = true; labAlert.Text = "没有任何资料!"; labAlert.Style.Add("color", "red"); } PageCount(); Page_Status(); Auto(); }
private void Auto() { int UserID; int PapersID; string Time; for (int i = 0; i < gv01.Rows.Count; i++) { Label lb_UserID = (Label)gv01.Rows[i].FindControl("lb_UserID"); Label lb_PapersID = (Label)gv01.Rows[i].FindControl("lb_PapersID"); Label lb_Time = (Label)gv01.Rows[i].FindControl("lb_Time"); UserID = int.Parse(lb_UserID.Text); PapersID = int.Parse(lb_PapersID.Text); Time = lb_Time.Text; BLL.Results bll = new BLL.Results(); List <Model.Results> list = new List <Model.Results>(); list = bll.Details(UserID, PapersID, Time); } gv01_Bind1(); }