/// <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();
}
