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