int intNeed, intPaper;//需要试卷数,已有试卷数。
BLL.V_Station_Curricula bll_Curricula = new V_Station_Curricula();
DataSet dataset_Curricula = bll_Curricula.GetList_GROUP(" 'CurriculaID'<>'0' GROUP BY CurriculaName, CurriculaID");
BLL.V_Paper bll_paper = new BLL.V_Paper();
BLL.V_EnterFor_Curricula bll_EnterFor_Curricula = new V_EnterFor_Curricula();
DataSet dataset_EnterFor_Curricula;
BLL.V_NoPass bll_NoPass = new V_NoPass();
DataSet dataset_NoPass;
StringBuilder strList=new StringBuilder();
strList.Append("<table cellspacing='0' cellpadding='5' rules='all' border='1' id='grid' style='border-width:1px;border-style:solid;width:100%;border-collapse:collapse;'>");
strList.Append("<tr >");
strList.Append(" <td width='200'>课程</td><td width='100'>需要试卷数</td><td width='100'>已有试卷数</td><td width='100'>操作</td>");
strList.Append("</tr>");
foreach(DataRow row__Curricula in dataset_Curricula.Tables [0].Rows )
{
dataset_EnterFor_Curricula = bll_EnterFor_Curricula.GetList(" DelSign='0' AND PlanID='"+listExamPlan.SelectedValue+"' AND IsPass='4' AND CurriculaID='"+row__Curricula["CurriculaID"]+"' AND CurriculaPassword='报考'" );
dataset_NoPass = bll_NoPass.GetList2("CurriculaID='"+row__Curricula["CurriculaID"]+"' AND PlanID <>'"+listExamPlan.SelectedValue +"'");
intNeed = dataset_EnterFor_Curricula.Tables[0].Rows.Count + dataset_NoPass.Tables[0].Rows.Count;
intPaper = bll_paper.GetList("PlanID='"+listExamPlan.SelectedValue +"' AND CurriculaID='"+row__Curricula["CurriculaID"]+"'").Tables[0].Rows.Count;