private void ShowData(string strSql)
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter(strSql, SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "UserAnswer");
RowNum = DataGridTestType.CurrentPageIndex * DataGridTestType.PageSize + 1;
string SortExpression = DataGridTestType.Attributes["SortExpression"];
string SortDirection = DataGridTestType.Attributes["SortDirection"];
SqlDS.Tables["UserAnswer"].DefaultView.Sort = SortExpression + " " + SortDirection;
DataGridTestType.DataSource = SqlDS.Tables["UserAnswer"].DefaultView;
DataGridTestType.DataBind();
for (int i = 0; i < DataGridTestType.Items.Count; i++)
{
System.Web.UI.WebControls.Image imgRate = (System.Web.UI.WebControls.Image)DataGridTestType.Items[i].FindControl("imgRate");
imgRate.Width = Convert.ToInt32(200 * Convert.ToDouble(DataGridTestType.Items[i].Cells[5].Text.Trim()) / Convert.ToDouble(DataGridTestType.Items[i].Cells[4].Text.Trim()));
imgRate.ToolTip = Convert.ToString(System.Math.Round(Convert.ToDouble(DataGridTestType.Items[i].Cells[5].Text.Trim()) / Convert.ToDouble(DataGridTestType.Items[i].Cells[4].Text.Trim()) * 100, 1)) + "%";
}
SqlConn.Dispose();
}
private void ShowPaperTestType()
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter("select a.PaperTestTypeID,a.TestTypeID,b.TestTypeName,b.BaseTestType,a.TestTypeTitle,a.TestTypeMark,a.TestAmount from PaperTestType a,TestTypeInfo b where a.TestTypeID=b.TestTypeID and a.PaperID=" + intPaperID + " order by a.PaperTestTypeID asc", SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "PaperTestType");
DataGridTestType.DataSource = SqlDS.Tables["PaperTestType"].DefaultView;
DataGridTestType.DataBind();
for (int i = 0; i < DataGridTestType.Items.Count; i++)
{
TextBox strTestTypeTitle = (TextBox)DataGridTestType.Items[i].FindControl("txtTestTypeTitle");
strTestTypeTitle.Text = SqlDS.Tables["PaperTestType"].Rows[i]["TestTypeTitle"].ToString();
TextBox strTestTypeMark = (TextBox)DataGridTestType.Items[i].FindControl("txtTestTypeMark");
strTestTypeMark.Text = SqlDS.Tables["PaperTestType"].Rows[i]["TestTypeMark"].ToString();
}
SqlConn.Dispose();
}
private void ShowData(string strSql)
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter(strSql, SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "TestTypeInfo");
RowNum = DataGridTestType.CurrentPageIndex * DataGridTestType.PageSize + 1;
LinNum = 0;
string SortExpression = DataGridTestType.Attributes["SortExpression"];
string SortDirection = DataGridTestType.Attributes["SortDirection"];
SqlDS.Tables["TestTypeInfo"].DefaultView.Sort = SortExpression + " " + SortDirection;
DataGridTestType.DataSource = SqlDS.Tables["TestTypeInfo"].DefaultView;
DataGridTestType.DataBind();
for (int i = 0; i < DataGridTestType.Items.Count; i++)
{
Label labUseState = (Label)DataGridTestType.Items[i].FindControl("labUseState");
if (ObjFun.GetValues("select TestTypeID from RubricInfo where TestTypeID=" + DataGridTestType.Items[i].Cells[0].Text.Trim() + "", "TestTypeID") != "")
{
labUseState.Text = "已使用";
}
else
{
labUseState.Text = "未使用";
}
LinkButton LBDel = (LinkButton)DataGridTestType.Items[i].FindControl("LinkButDel");
LBDel.Attributes.Add("onclick", "javascript:{if(confirm('确定要删除选择题型吗？')==false) return false;}");
}
LabelRecord.Text = Convert.ToString(SqlDS.Tables["TestTypeInfo"].Rows.Count);
LabelCountPage.Text = Convert.ToString(DataGridTestType.PageCount);
LabelCurrentPage.Text = Convert.ToString(DataGridTestType.CurrentPageIndex + 1);
SqlConn.Dispose();
}
