private void GradeClass()
{
if (Request.Cookies[LearnSite.Common.CookieHelp.teaCookieNname] != null)
{
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
string Hid = tcook.Hid.ToString();
DDLgrade.DataSource = room.GetGrade(Int32.Parse(Hid));
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
if (Session[Hid + "grade"] != null)
{
DDLgrade.SelectedValue = Session[Hid + "grade"].ToString();
}
int Rgrade = Int32.Parse(DDLgrade.SelectedValue);
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
DDLclass.DataSource = rm.GetLimitClass(Rgrade);
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
if (Session[Hid + "class"] != null)
{
DDLclass.SelectedValue = Session[Hid + "class"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.userId = Convert.ToInt32(Session["userID"].ToString());
if (!IsPostBack)
{
string sql1 = "select * from province";
DataSet ds1 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql1);
DataTable dt1 = ds1.Tables[0];
DDLprovince.DataSource = dt1;
DDLprovince.DataBind();
string sql2 = "select * from school";
DataSet ds2 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql2);
DataTable dt2 = ds2.Tables[0];
DDLschool.DataSource = dt2;
DDLschool.DataBind();
string sql3 = "select * from grade";
DataSet ds3 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql3);
DataTable dt3 = ds3.Tables[0];
DDLgrade.DataSource = dt3;
DDLgrade.DataBind();
}
this.userName = Session["userName"].ToString();
this.id = Session["userID"].ToString();
string sql = "select * from users where id=@id";
DataSet ds = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql, new MySqlParameter("@id", id));
DataTable dt = ds.Tables[0];
string img = dt.Rows[0]["logo"].ToString();
pic.ImageUrl = img;
pic_mid.ImageUrl = img;
pic_s.ImageUrl = img;
}
private void GradeClass()
{
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
LearnSite.Model.TeaCook tcook = new LearnSite.Model.TeaCook();
string Hid = tcook.Hid.ToString();
DDLgrade.DataSource = rm.GetGrade(Int32.Parse(Hid));
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
if (Request.QueryString["Sgrade"] != null)
{
DDLgrade.SelectedValue = Request.QueryString["Sgrade"].ToString();
}
DDLgrade.Enabled = false;
int Rgrade = Int32.Parse(DDLgrade.SelectedValue);
DDLclass.DataSource = rm.GetLimitClass(Rgrade);
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
if (Request.QueryString["Sclass"] != null)
{
DDLclass.SelectedValue = Request.QueryString["Sclass"].ToString();
}
DDLclass.Enabled = false;
}
private void Grade()
{
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
}
private void showGrade()
{
LearnSite.BLL.Room rbll = new LearnSite.BLL.Room();
DDLgrade.DataSource = rbll.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
}
private void myGrade()
{
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
string Hid = tcook.Hid.ToString();
DDLgrade.DataSource = room.GetGrade(Int32.Parse(Hid));
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
}
private void GradeClass()
{
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetFindGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
DDLclass.DataSource = rm.GetFindClass();
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
}
private void ShowGrade()
{
LearnSite.BLL.Room rbll = new LearnSite.BLL.Room();
DDLgrade.DataSource = rbll.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
if (LearnSite.Common.CookieHelp.IsStudentLogin())
{
string Cobj = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString();
DDLgrade.SelectedValue = Cobj;
}
if (Request.QueryString["Cobj"] != null)
{
DDLgrade.SelectedValue = Request.QueryString["Cobj"].ToString();
}
}
private void GradeClass()
{
string Sgrade = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString();
string Sclass = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLgrade.SelectedValue = Sgrade;
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
DDLclass.DataSource = rm.GetClass();
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
DDLclass.SelectedValue = Sclass;
}
private void Grade()
{
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DDLYear.DataSource = tbll.TyearList();
DDLYear.DataTextField = "Tyear";
DDLYear.DataValueField = "Tyear";
DDLYear.DataBind();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLclass.DataSource = room.GetClass();
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
}
private void Grade()
{
LearnSite.BLL.TermTotal tbll = new LearnSite.BLL.TermTotal();
DDLYear.DataSource = tbll.TyearList();
DDLYear.DataTextField = "Tyear";
DDLYear.DataValueField = "Tyear";
DDLYear.DataBind();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLgrade.SelectedIndex = 0;
DDLclass.DataSource = room.GetLimitClass(Int32.Parse(DDLgrade.SelectedValue));
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
}
private void GradeClass()
{
LearnSite.Model.Cook cook = new LearnSite.Model.Cook();
string Sgrade = cook.Sgrade.ToString();
string Sclass = cook.Sclass.ToString();
LearnSite.BLL.Room room = new LearnSite.BLL.Room();
DDLgrade.DataSource = room.GetAllGrade();
DDLgrade.DataTextField = "Rgrade";
DDLgrade.DataValueField = "Rgrade";
DDLgrade.DataBind();
DDLgrade.SelectedValue = Sgrade;
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
DDLclass.DataSource = rm.GetAllClass();
DDLclass.DataTextField = "Rclass";
DDLclass.DataValueField = "Rclass";
DDLclass.DataBind();
DDLclass.SelectedValue = Sclass;
}
/// <summary>
/// 绑定 省 年纪 学校的方法
/// </summary>
protected void DDLbind()
{
string sql1 = "select * from province";
DataSet ds1 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql1);
DataTable dt1 = ds1.Tables[0];
DDLprovince.DataSource = dt1;
DDLprovince.DataBind();
string sql2 = "select * from school";
DataSet ds2 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql2);
DataTable dt2 = ds2.Tables[0];
DDLschool.DataSource = dt2;
DDLschool.DataBind();
string sql3 = "select * from grade";
DataSet ds3 = MySqlHelper.GetDataSet(MySqlHelper.Conn, System.Data.CommandType.Text, sql3);
DataTable dt3 = ds3.Tables[0];
DDLgrade.DataSource = dt3;
DDLgrade.DataBind();
}