private void ShowSubjectInfo()
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter("select * from SubjectInfo order by SubjectID", SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "SubjectInfo");
DDLSubjectName.Items.Clear();
DDLSubjectName.DataSource = SqlDS.Tables["SubjectInfo"].DefaultView;
DDLSubjectName.DataTextField = "SubjectName";
DDLSubjectName.DataValueField = "SubjectID";
DDLSubjectName.DataBind();
SqlConn.Dispose();
ListItem strTmp = new ListItem("--请选择--", "0");
DDLSubjectName.Items.Add(strTmp);
}
private void ShowSubjectInfo()
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter("select a.* from SubjectInfo a where (a.BrowAccount=1 or (a.BrowAccount=2 and Exists(select * from SubjectUser b where b.SubjectID=a.SubjectID and b.UserID=" + intUserID + ")) or Exists(select * from UserInfo c,DeptInfo d,SubjectUser e where c.UserID=" + intUserID + " and c.DeptID=d.DeptID and d.DeptID=e.DeptID and e.SubjectID=a.SubjectID)) order by a.SubjectName asc", SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "SubjectInfo");
DDLSubjectName.Items.Clear();
DDLSubjectName.DataSource = SqlDS.Tables["SubjectInfo"].DefaultView;
DDLSubjectName.DataTextField = "SubjectName";
DDLSubjectName.DataValueField = "SubjectID";
DDLSubjectName.DataBind();
SqlConn.Dispose();
ListItem strTmp = new ListItem("--全部--", "0");
DDLSubjectName.Items.Add(strTmp);
}
