protected void Page_Load(object sender, EventArgs e)
{
//获取所有老师
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from teacher", sqlConnection);
DataSet dataSet1 = new DataSet();
sqlDataAdapter1.Fill(dataSet1);
//所有老师绑定到系别下拉框
DropDownListTeacher.DataSource = dataSet1;
DropDownListTeacher.DataTextField = "name";
DropDownListTeacher.DataBind();
//获取所有教室
SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter("select * from classroom", sqlConnection);
DataSet dataSet2 = new DataSet();
sqlDataAdapter2.Fill(dataSet2);
//所有教室绑定到系别下拉框
DropDownListPlace.DataSource = dataSet2;
DropDownListPlace.DataTextField = "id";
DropDownListPlace.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownListTeacher.Items.Clear();
DropDownListTeacher.Items.Add(new ListItem("--Select Teacher--", ""));
DropDownListTeacher.AppendDataBoundItems = true;
String strConnString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
String strQuery = "select TID, TName from tbl_Teacher";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
DropDownListTeacher.DataSource = cmd.ExecuteReader();
DropDownListTeacher.DataTextField = "TName";
DropDownListTeacher.DataValueField = "TID";
DropDownListTeacher.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
//if (!IsPostBack)
//{
// DropDownListDepartment.DataSource= getData("spGetDept", null);
// DropDownListDepartment.DataBind();
// ListItem listDept = new ListItem("Select Dept", "-1");
// DropDownListDepartment.Items.Insert(0, listDept);
// ListItem listTeacher = new ListItem("Select Teacher", "-1");
// DropDownListTeacher.Items.Insert(0, listTeacher);
// //DropDownListTeacher.Enabled = false;
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
userID = Int32.Parse(Session["UserID"].ToString());
eRegisterData.DAL DAL = new eRegisterData.DAL();
SqlConnection conn = DAL.getSubject();
SqlCommand comm = new SqlCommand();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = @" SELECT ActorID
FROM Actors
WHERE UserID='" + userID + "'";
studentID = Int32.Parse(comm.ExecuteScalar().ToString());
conn.Close();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
System.Data.DataTable teacherNameInfo = new System.Data.DataTable();
eRegisterData.DAL oDal = new eRegisterData.DAL();
if (!IsPostBack)
{
teacherNameInfo = oDal.GetTeacherList(studentID);
DropDownListTeacher.DataSource = teacherNameInfo.DefaultView;
DropDownListTeacher.DataTextField = teacherNameInfo.Columns["TeacherName"].ColumnName.ToString();
DropDownListTeacher.DataValueField = teacherNameInfo.Columns["TeacherID"].ColumnName.ToString();
DropDownListTeacher.DataBind();
DropDownListTeacher.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListTeacher.SelectedIndex = DropDownListTeacher.Items.Count - 1;
}
messageID = Request.QueryString["messageID"];
if (messageID != string.Empty)
{
StatusID = oDal.MessageStatusID(messageID);
if (StatusID == 1)
{
System.Data.DataTable dt = oDal.MessageDraft(messageID);
DropDownListTeacher.ClearSelection();
ListItem selectedListItem = DropDownListTeacher.Items.FindByValue(dt.Rows[0][0].ToString());
if (selectedListItem != null)
{
selectedListItem.Selected = true;
}
txtMessage.Text = dt.Rows[0][1].ToString();
}
else
{
try
{
messageFrom = oDal.MessageReply(messageID);
}
catch (Exception ex)
{
lblError.Text = "No link to the Data Server!";
}
DropDownListTeacher.ClearSelection();
ListItem selectedListItem = DropDownListTeacher.Items.FindByValue(messageFrom.ToString());
if (selectedListItem != null)
{
selectedListItem.Selected = true;
DropDownListTeacher.Enabled = false;
}
else
{
}
}
}
}
else
{
Response.Redirect("~/eRegister.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
userID = Int32.Parse(Session["UserID"].ToString());
eRegisterData.DAL DAL = new eRegisterData.DAL();
SqlConnection conn = DAL.getSubject();
SqlCommand comm = new SqlCommand();
try
{
conn.Open();
comm.Connection = conn;
comm.CommandText = @" SELECT ActorID
FROM Actors
WHERE UserID='" + userID + "'";
studentID = Int32.Parse(comm.ExecuteScalar().ToString());
conn.Close();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
if (!IsPostBack)
{
System.Data.DataTable teacherName = new System.Data.DataTable();
eRegisterData.DAL oDal = new eRegisterData.DAL();
teacherName = oDal.GetActors(2);
DropDownListTeacher.DataSource = teacherName.DefaultView;
DropDownListTeacher.DataTextField = teacherName.Columns["Name"].ColumnName.ToString();
DropDownListTeacher.DataValueField = teacherName.Columns["ActorID"].ColumnName.ToString();
DropDownListTeacher.DataBind();
DropDownListTeacher.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListTeacher.SelectedIndex = DropDownListTeacher.Items.Count - 1;
System.Data.DataTable parentName = new System.Data.DataTable();
eRegisterData.DAL oDal1 = new eRegisterData.DAL();
parentName = oDal1.GetActors(3);
DropDownListParent.DataSource = parentName.DefaultView;
DropDownListParent.DataTextField = parentName.Columns["Name"].ColumnName.ToString();
DropDownListParent.DataValueField = parentName.Columns["ActorID"].ColumnName.ToString();
DropDownListParent.DataBind();
DropDownListParent.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListParent.SelectedIndex = DropDownListParent.Items.Count - 1;
System.Data.DataTable studentName = new System.Data.DataTable();
eRegisterData.DAL oDal2 = new eRegisterData.DAL();
studentName = oDal2.GetActors(4);
DropDownListStudent.DataSource = studentName.DefaultView;
DropDownListStudent.DataTextField = studentName.Columns["Name"].ColumnName.ToString();
DropDownListStudent.DataValueField = studentName.Columns["ActorID"].ColumnName.ToString();
DropDownListStudent.DataBind();
DropDownListStudent.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListStudent.SelectedIndex = DropDownListStudent.Items.Count - 1;
System.Data.DataTable messageTypeInfo = new System.Data.DataTable();
eRegisterData.DAL oDal3 = new eRegisterData.DAL();
messageTypeInfo = oDal3.getMessageType();
DropDownListMessageType.DataSource = messageTypeInfo.DefaultView;
DropDownListMessageType.DataTextField = messageTypeInfo.Columns["Type"].ColumnName.ToString();
DropDownListMessageType.DataValueField = messageTypeInfo.Columns["MessageTypeID"].ColumnName.ToString();
DropDownListMessageType.DataBind();
DropDownListMessageType.Items.Add(new ListItem("Моля изберете", "-1"));
DropDownListMessageType.SelectedIndex = DropDownListMessageType.Items.Count - 1;
}
}
else
{
Response.Redirect("~/eRegister.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//获取要编辑课程
string id = Request.QueryString["id"];
Course c = (Course)dao.getBody(id, 4);
TextBoxID.Text = c.ID;
TextBoxName.Text = c.Name;
TextBoxScore.Text = c.Score;
TextBoxDate.Text = c.Date;
//获取所有老师
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from teacher", sqlConnection);
DataSet dataSet1 = new DataSet();
sqlDataAdapter1.Fill(dataSet1);
//所有老师绑定到系别下拉框
DropDownListTeacher.DataSource = dataSet1;
DropDownListTeacher.DataTextField = "name";
DropDownListTeacher.DataBind();
//下拉框选中该课程老师
//1.查询老师编号对应的老师姓名
string teacherName = "";
string sql1 = string.Format("select name from teacher where id='{0}'", c.Teacher);
IDataReader idr = SqlTools.Read(sql1);
if (idr.Read())
{
teacherName = idr.GetString(0);
}
//2.选中
DropDownListTeacher.SelectedValue = teacherName;
//绑定上课时间
string[] dayAndNode = c.Time.Split(',');
for (int i = 0; i < dayAndNode.Length; i++)
{
//第一个字符为1说明是星期一
if (dayAndNode[i].Substring(0, 1).Equals("1"))
{
RadioButtonMonday.Checked = true;
DropDownListMonday.SelectedValue = dayAndNode[i].Substring(2, 1);
}
else if (dayAndNode[i].Substring(0, 1).Equals("2"))
{
RadioButtonTuesday.Checked = true;
DropDownListTuesday.SelectedValue = dayAndNode[i].Substring(2, 1);
}
else if (dayAndNode[i].Substring(0, 1).Equals("3"))
{
RadioButtonWed.Checked = true;
DropDownListWednesday.SelectedValue = dayAndNode[i].Substring(2, 1);
}
else if (dayAndNode[i].Substring(0, 1).Equals("4"))
{
RadioButtonThur.Checked = true;
DropDownListThursday.SelectedValue = dayAndNode[i].Substring(2, 1);
}
else if (dayAndNode[i].Substring(0, 1).Equals("5"))
{
RadioButtonFri.Checked = true;
DropDownListFriday.SelectedValue = dayAndNode[i].Substring(2, 1);
}
}
//绑定课程周次
string[] startAndEnd = c.Week.Split('-');
DropDownListStart.SelectedValue = startAndEnd[0];
DropDownListEnd.SelectedValue = startAndEnd[1];
//获取所有教室
SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter("select * from classroom", sqlConnection);
DataSet dataSet2 = new DataSet();
sqlDataAdapter2.Fill(dataSet2);
//所有教室绑定到系别下拉框
DropDownListPlace.DataSource = dataSet2;
DropDownListPlace.DataTextField = "id";
DropDownListPlace.DataBind();
//选中上课地点
DropDownListTeacher.SelectedValue = c.Place;
sqlConnection.Close();
}
//不能改课程号
TextBoxID.Enabled = false;
}
