/// <summary> /// 绑定存在问题的序号 /// </summary> private void ProblemIndexDataBind() { ProbIndex prob = new ProbIndex(); prob.StrTabeleName = ViewState["str_table"].ToString(); prob.TaskID = ViewState["TaskId"].ToString(); DataTable dt = this.ExecRetProbTable(prob); grvProb.DataSource = dt; grvProb.DataBind(); if (grvProb.Rows.Count > 0) { NoDataPanel.Visible = false; } else { NoDataPanel.Visible = true; } }
/// <summary> /// 执行存储过程验证序号(保存时) /// </summary> /// <param name="psv"></param> private DataTable ExecRetProbTable(ProbIndex probindex) { DataTable dt; try { SqlConnection sqlConn = new SqlConnection(); SqlCommand sqlCmd = new SqlCommand(); sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings"); DBCallCommon.PrepareStoredProc(sqlConn, sqlCmd, "[PRO_TM_FindNoFatherIndex]"); DBCallCommon.AddParameterToStoredProc(sqlCmd, "@StrTable", probindex.StrTabeleName, SqlDbType.Text, 1000); DBCallCommon.AddParameterToStoredProc(sqlCmd, "@BM_ENGID", probindex.TaskID, SqlDbType.Text, 1000); sqlConn.Open(); dt = DBCallCommon.GetDataTableUsingCmd(sqlCmd); sqlConn.Close(); } catch (Exception) { throw; } return(dt); }