protected void rptCourse_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (AddSQLStringToDAL.UpdateMessage(Session["UserID"].ToString()))
{
Response.Redirect("教师首页.aspx");
}
}
private void InsertCoursesSimpleMap(List <string> strDistinctTeacherID)
{
for (int i = 0; i < strDistinctTeacherID.Count; i++)
{
List <string> strDD = new List <string>();
strDD = AddSQLStringToDAL.GetDistinctStrings("TabAllCourses", "TimeAndArea", "TeacherID", strDistinctTeacherID[i].ToString());//获取TimeAndArea
for (int k = 0; k < strDD.Count; k++)
{
List <string> strResult = new List <string>();
strResult = SplitString.GetSplitCountAndDetails(strDD[k]);
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabAllCourses where TeacherID = '" + strDistinctTeacherID[i].ToString() + "' and TimeAndArea = '" + strDD[k].ToString() + "'");
for (int j = 0; j < (strResult.Count / 4); j++)
{
string WeekRange = SplitString.GetWithoutWeek(strResult[j * 4 + 0].ToString());//如果想用空格隔开，只是在最后加一个空格（以，作为例子试的）
string Week = strResult[j * 4 + 1].ToString();
string Time = strResult[j * 4 + 2].ToString();
string Area = strResult[j * 4 + 3].ToString();
string Course = dt.Rows[0]["Course"].ToString().Trim();
if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherCourseSimpleMap", strDistinctTeacherID[i].ToString(), dt.Rows[0]["TeacherName"].ToString(), Course, WeekRange, Week, Time, strDD[k].ToString(), dt.Rows[0]["Class"].ToString(), dt.Rows.Count.ToString(), dt.Rows[0]["TeacherDepartment"].ToString(), dt.Rows[0]["StudentDepartment"].ToString(), Area))
{
}
}
dt.Clear();
}
}
}
public void CurrentWeek()
{
Session["CurrentWeek"] = "0";
try
{
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from [校历] ");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToDateTime(dt.Rows[i]["StartWeek"]) < DateTime.Now && Convert.ToDateTime(dt.Rows[i]["EndWeek"]) > DateTime.Now)
{
string strWeekNumber = dt.Rows[i]["WeekNumber"].ToString();
if (strWeekNumber.Length == 1)
{
strWeekNumber = "0" + strWeekNumber;
}
Session["CurrentWeek"] = strWeekNumber;
break;
}
else
{
Session["CurrentWeek"] = "0";//不满足所有周次
}
}
}
catch
{
Session["CurrentWeek"] = "0";
}
}
protected void BtnDepartmentCount_Click(object sender, EventArgs e)
{
string[] str = { "会计系", "信息工程系", "经济管理系", "食品工程系", "机械工程系", "商务外语系", "建筑工程系" };
int[] sum = new int[str.Length];
if (txtKJ.Text != "" && txtXX.Text != "" && txtJG.Text != "" && txtSP.Text != "")
// && txtJX.Text != "" && txtWY.Text != "" && txtJZ.Text != ""
{
sum[0] = Convert.ToInt32(txtKJ.Text.Trim());
sum[1] = Convert.ToInt32(txtXX.Text.Trim());
sum[2] = Convert.ToInt32(txtJG.Text.Trim());
sum[3] = Convert.ToInt32(txtSP.Text.Trim());
//sum[4] = Convert.ToInt32(txtJX.Text.Trim());
//sum[5] = Convert.ToInt32(txtWY.Text.Trim());
//sum[6] = Convert.ToInt32(txtJZ.Text.Trim());
}
if (AddSQLStringToDAL.DeleteTabTeachers("TabDepartment"))
{
for (int i = 0; i < str.Length; i++)
{
string strSql = "INSERT INTO TabDepartment VALUES('" + str[i] + "','" + sum[i] + "')";
if (AddSQLStringToDAL.InsertData(strSql))
{
Label16.Text = "各系人数设置完毕";
}
else
{
Label16.Text = "设置失败";
}
}
}
}
private void initalPWD()
{
List <string> str = new List <string>();
str = AddSQLStringToDAL.GetDistinctString("TabTeachers", "UserID");
for (int i = 0; i < str.Count; i++)
{
if (AddSQLStringToDAL.UpdataTabTeachers("TabTeachers", PWDProcess.MD5Encrypt(str[i].ToString(), PWDProcess.CreatKey(str[i].ToString())), str[i].ToString()))
{
;
}
{
}
}
List <string> str2 = new List <string>();
str2 = AddSQLStringToDAL.GetDistinctString("TabOtherTeachers", "UserID");
for (int i = 0; i < str2.Count; i++)
{
if (AddSQLStringToDAL.UpdataTabTeachers("TabOtherTeachers", PWDProcess.MD5Encrypt(str2[i].ToString(), PWDProcess.CreatKey(str2[i].ToString())), str2[i].ToString()))
{
}
}
}
protected void Button5_Click(object sender, EventArgs e)//导入系部人数按钮
{
if (TextBox1.Text != "" && TextBox2.Text != "" && TextBox3.Text != "" && TextBox4.Text != "" && TextBox5.Text != "" && TextBox6.Text != "" && TextBox7.Text != "")
{
string[] str = { "会计系", "信息工程系", "经济管理系", "食品工程系", "机械工程系", "商务外语系", "建筑工程系" };
int[] sum = new int[str.Length];
sum[0] = Convert.ToInt32(TextBox1.Text.Trim());
sum[1] = Convert.ToInt32(TextBox2.Text.Trim());
sum[2] = Convert.ToInt32(TextBox3.Text.Trim());
sum[3] = Convert.ToInt32(TextBox4.Text.Trim());
sum[4] = Convert.ToInt32(TextBox5.Text.Trim());
sum[5] = Convert.ToInt32(TextBox6.Text.Trim());
sum[6] = Convert.ToInt32(TextBox7.Text.Trim());
if (AddSQLStringToDAL.DeleteTabTeachers("TabDepartmentSum"))
{
}
for (int i = 0; i < str.Length; i++)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabDepartmentSum", str[i], sum[i].ToString()))
{
label6.Visible = true;
label6.Text = "各系人数设置完毕！";
}
}
}
else
{
label6.Visible = true;
label6.Text = "部分系部人数未设置，请全部设置！";
}
}
//删除
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (AddSQLStringToDAL.DeleteRows("TabTeachers", "User_ID", GridView1.DataKeys[e.RowIndex].Value.ToString()))
{
BindData();
}
}
protected void btnEnter_Click(object sender, EventArgs e)
{
if (txtUserID.Text.ToString().ToLower().IndexOf("delete") != -1 || txtUserID.Text.ToString().ToLower().IndexOf(";") != -1 || txtUserID.Text.ToString().ToLower().IndexOf("select") != -1 || txtUserID.Text.ToString().ToLower().IndexOf("insert") != -1 || txtUserID.Text.ToString().ToLower().IndexOf("update") != -1 || txtUserPWD.Text.ToString().ToLower().IndexOf("select") != -1 || txtUserPWD.Text.ToString().ToLower().IndexOf(";") != -1 || txtUserPWD.Text.ToString().ToLower().IndexOf("delete") != -1 || txtUserPWD.Text.ToString().ToLower().IndexOf("insert") != -1 || txtUserPWD.Text.ToString().ToLower().IndexOf("update") != -1 || txtUserName.Text.ToString().ToLower().IndexOf("update") != -1 || txtUserName.Text.ToString().ToLower().IndexOf("insert") != -1 || txtUserName.Text.ToString().ToLower().IndexOf("select") != -1 || txtUserName.Text.ToString().ToLower().IndexOf("delete") != -1 || txtUserName.Text.ToString().ToLower().IndexOf(";") != -1)
{
lblMessage.Visible = true;
lblMessage.Text = "(含有关键词！请重新输入！)";
}
else
{
try//和数据库UserID不能为空且唯一对应，try catch 异常处理
{
if (txtUserID.Text != "" && txtUserPWD.Text != "" && txtUserName.Text != "")
{
AddSQLStringToDAL.Insert("TabTeachers", ddlTeachersType.SelectedItem.ToString(), ddlDepartment.SelectedItem.ToString(), txtUserID.Text, txtUserName.Text, FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPWD.Text, "MD5").ToString(), ddlRole.SelectedItem.ToString());
Clear();
lblMessage.Visible = true;
lblMessage.Text = "添加成功";
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "教师工号、姓名或密码不能为空";
}
}
catch
{
Clear();
lblMessage.Visible = true;
lblMessage.Text = "输入有误！请核对教师工号等信息！教师工号不能重复！";
}
}
}
private int changePWD(string ymm, string newPWD)
{
string ymm1 = BLL.Tools.PWDProcess.Encrypt(ymm);
string sql = "SELECT user_pwd from TabTeachers where user_id='" + Session["UserID"] + "'";
DataTable dt = AddSQLStringToDAL.getDt(sql);
if (dt.Rows.Count == 1)
{
if (ymm1 == dt.Rows[0]["user_pwd"].ToString())
{
string sql1 = "UPDATE tabteachers SET user_pwd='" + ymm1 + "' WHERE user_id = '" + Session["UserID"] + "' ";
bool flag = AddSQLStringToDAL.changePWD(sql1);
if (flag)
{
return(1);
}
}
else
{
return(2);
}
}
return(0);
}
protected void rptCourse_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (AddSQLStringToDAL.DeleteTabTeachers("TabMessage", Session["UserID"].ToString()))
{
Response.Redirect("管理员首页.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int departmentPos = DropDownList1.SelectedIndex;
int rolePos = DropDownList2.SelectedIndex;
string[] departments = { "信息与艺术设计系", "经管系", "商务外语系" };
string[] roles = { "1", "2", "3" };
string userID = TextBox1.Text.ToString();
string username = TextBox2.Text.ToString();
string sex = TextBox3.Text.ToString();
if (userID != "" && username != "" && sex != "")
{
string sql = "INSERT INTO TabTeachers (department,user_id,user_pwd,user_name,sex,role) VALUES ('" + departments[departmentPos] + "','" + userID + "','" + userID + "','" + username + "','" + sex + "','" + roles[rolePos] + "')";
if (AddSQLStringToDAL.AddNewUser(userID, sql))
{
Response.Write(sql);
Response.Write(userID + " 用户添加成功，默认密码为工号");
}
else
{
Response.Write("添加用户失败");
}
}
else
{
Response.Write("请输入完整数据！");
}
}
protected void gvTeachers_RowDeleting(object sender, GridViewDeleteEventArgs e) //删除
{
if (AddSQLStringToDAL.DeleteTabTeachers("TabTeachers", gvTeachers.DataKeys[e.RowIndex].Value.ToString()))
{
Bind();
}
}
//删除
protected void gvTeachers_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strSql = "delete from TabTeachers where UserID='" + gvTeachers.DataKeys[e.RowIndex].Value.ToString() + "'";
AddSQLStringToDAL.InsertData(strSql);
Bind();
}
private void InitialPWD()//密码加密
{
List <string> str = new List <string>();
str = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID");
for (int i = 0; i < str.Count; i++)
{
if (AddSQLStringToDAL.UpdateTabTeachers("TabAllTeachers", FormsAuthentication.HashPasswordForStoringInConfigFile(str[i].ToString(), "MD5").ToString(), str[i].ToString()))
{
lblMessage3.Text = "正在初始化密码...";
}
}
List <string> str1 = new List <string>();
str1 = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID");
for (int i = 0; i < str1.Count; i++)
{
if (AddSQLStringToDAL.UpdateTabTeachers("TabTeachers", FormsAuthentication.HashPasswordForStoringInConfigFile(str[i].ToString(), "MD5").ToString(), str[i].ToString()))
{
lblMessage3.Text = "正在初始化密码...";
}
}
List <string> str2 = new List <string>();
str2 = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID");
for (int i = 0; i < str2.Count; i++)
{
if (AddSQLStringToDAL.UpdateTabTeachers("TabOtherTeachers", PWDProcess.MD5Encrypt(str2[i].ToString(), PWDProcess.CreateKey(str2[i].ToString())), str2[i].ToString()))
{
lblMessage3.Text = "正在初始化密码...";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["CurrentWeek"].ToString() != "")
{
btnClose.Visible = true;
Label1.Visible = false;
}
else
{
Response.Redirect("~\\登录.aspx");
}
string LastWeek = (Convert.ToInt32(Session["CurrentWeek"].ToString()) - 1).ToString();
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from [TabTeacherAttendance] where TeacherID = '" + Session["UserID"].ToString() + "' and CurrentWeek = '" + LastWeek + "' and Course = '" + Session["CurrentCourse"].ToString() + "' and Week = '" + Session["Week"].ToString() + "' and Time = '" + Session["Time"].ToString() + "' and Count = '已布置作业'");
if (dt.Rows.Count == 0)
{
lblResultMessage.Text = "您已经批改本次作业！";
lblHomeWorkMessage.Visible = false;
gvHomeworkDetails.Visible = false;
btnAttdance.Visible = false;
}
else
{
string strCourse = Session["CurrentCourse"].ToString();
lblMessage.Text = Session["Week"].ToString() + Session["Time"].ToString() + "|" + strCourse.Substring(8, strCourse.Length - 11) + "|" + this.gvHomeworkDetails.Rows.Count.ToString() + "人";
c = this.gvHomeworkDetails.BackColor;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
else
{
if (txtUserPWD.Text == "")
{
txtUserEnterPWD.Text = "";
lblMessage.Text = "修改失败！密码不能为空！";
}
else
{
if (txtUserPWD.Text != txtUserEnterPWD.Text)
{
txtUserPWD.Text = "";
txtUserEnterPWD.Text = "";
lblMessage.Text = "修改失败！两次密码不一致！";
}
else
{
AddSQLStringToDAL.Update("TabTeachers", "UserPWD", FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPWD.Text, "MD5").ToString(), "UserID", txtUserID.Text);
lblMessage.Text = "修改成功!";
}
}
}
}
protected void btnAttdance_Click(object sender, EventArgs e)//上报
{
StringBuilder strNO = new StringBuilder("未完成作业名单:");
int sum = 0;
foreach (GridViewRow row in this.gvHomeworkDetails.Rows)
{
Control ctl2 = row.FindControl("rdoNO");
TableCellCollection cell = row.Cells;
if ((ctl2 as RadioButton).Checked)
{
if (AddSQLStringToDAL.InsertTabTeachers("TabStudentHomework", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "未完成", ""))
{
sum++;
strNO.Append(cell[3].Text.ToString() + ";");//添加上姓名
}
}
}
if (strNO.ToString() == "未完成作业名单:")
{
strNO.Append("无");
}
if (AddSQLStringToDAL.UpdateTabTeachers("TabTeacherAttendance", "Count", "已批改作业", "IsAttendance", "已考勤", "TeacherID", Session["UserID"].ToString(), "Course", Session["CurrentCourse"].ToString(), "CurrentWeek", (Convert.ToInt32(Session["CurrentWeek"].ToString()) - 1).ToString(), "Week", Session["Week"].ToString(), "Time", Session["Time"].ToString()))
{
lblHomeWorkMessage.Text = strNO.ToString();
lblResultMessage.Text = "本次作业记录已经上报成功！请返回主页面！";
btnClose.Visible = true;
}
gvHomeworkDetails.Visible = false;
}
//更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (AddSQLStringToDAL.UpdateRows("TabTeachers", "Role", ((DropDownList)GridView1.Rows[e.RowIndex].Cells[3].Controls[1]).SelectedItem.Value.ToString().Trim(), "User_ID", GridView1.DataKeys[e.RowIndex].Value.ToString()))
{
GridView1.EditIndex = -1;
BindData();
}
}
protected void btnClearPreData_Click(object sender, EventArgs e)
{
Clear();
if (AddSQLStringToDAL.DeleteTabTeachers("TabTeacherstatus") && AddSQLStringToDAL.DeleteTabTeachers("TabTeacherCourseSimpleMap") && AddSQLStringToDAL.DeleteTabTeachers("TabTeacherAttendance") && AddSQLStringToDAL.DeleteTabTeachers("TabStudentAttendance") && AddSQLStringToDAL.DeleteTabTeachers("TabTeacherHome"))
{
lbMessage4.Text = "异常数据清空完毕！请对数据进行分析和处理";
}
}
private DataTable GetHomeworkDt(string Week, string Department)
{
DataTable dt;
dt = AddSQLStringToDAL.GetDataTableBysql("SELECT [TeacherID] as '教师工号',[TeacherName] as '教师姓名',[Course] as '课程名称',[CurrentWeek] as '周次',[Week] as '星期',[Time] as '节次',[StudentDepartment] as '学生系部',[StudentClass] as '课程信息',[StudentID] as '学生学号',[StudentName] as '学生姓名',[HomeworkType] as '异常类型' FROM [TabStudentHomework] where StudentDepartment = '" + Department + "' and CONVERT(int,CurrentWeek) <= '" + Week + "'");
return(dt);
}
private void BindData()
{
GridView1.AllowPaging = true;
GridView1.PageSize = 10;
GridView1.DataSource = AddSQLStringToDAL.GetTeachersInfo();
GridView1.DataKeyNames = new string[] { "User_ID" };
GridView1.DataBind();
}
protected void Button4_Click(object sender, EventArgs e)//清空入库数据
{
Clear();
if (AddSQLStringToDAL.DeleteTabTeachers("TabTeacherStatus") && AddSQLStringToDAL.DeleteTabTeachers("TabTeacherCourseSimpleMap") && AddSQLStringToDAL.DeleteTabTeachers("TabTeacherAttendance") && AddSQLStringToDAL.DeleteTabTeachers("TabStudentAttendance") && AddSQLStringToDAL.DeleteTabTeachers("TabStudentHomework") && AddSQLStringToDAL.DeleteTabTeachers("校历"))
{
lblMessage4.Text = "异常数据清空完毕！请对数据进行分析和处理！";
}
}
private void GetTeacherCourseSimpleMap()
{
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabTeacherCourseSimpleMap");
foreach (DataRow dr in dt.Rows)
{
string[] strT = dr["WeekRange"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < strT.Length; i++)
{
string WeekNumber = "";
string TeacherDepartment = dr["TeacherDepartment"].ToString();
string TeacherID = dr["TeacherID"].ToString();
string TeacherName = dr["TeacherName"].ToString();
string Week = dr["Week"].ToString();
switch (Week)
{
case "星期一":
WeekNumber = "1";
break;
case "星期二":
WeekNumber = "2";
break;
case "星期三":
WeekNumber = "3";
break;
case "星期四":
WeekNumber = "4";
break;
case "星期五":
WeekNumber = "5";
break;
case "星期六":
WeekNumber = "6";
break;
default:
WeekNumber = "7";
break;
}
string Time = dr["Time"].ToString();
string Course = dr["Course"].ToString();
string Area = dr["Area"].ToString();
if (strT[i].Length == 1)
{
strT[i] = "0" + strT[i];
}
if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherAttendance", WeekNumber, TeacherDepartment, TeacherID, TeacherName, strT[i].ToString(), Week, Time, Course, Area, "未考勤", "", dr["WithoutWeek"].ToString(), "", ""))
{
}
}
lblMessage7.Text = "数据处理完毕！";
}
}
//已读按钮的点击
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
Label msgID = e.Item.FindControl("msgID") as Label;
string readMsgTemp = Session["readMsg"].ToString() == "" ? msgID.Text : Session["readMsg"].ToString() + " " + msgID.Text;
AddSQLStringToDAL.UpdateRows("TabTeachers", "read_msg", readMsgTemp, "user_id", Session["userID"].ToString());
Session["readMsg"] = readMsgTemp;
bindData();
}
protected void BindToGridView(string strSql)
{
DataTable dt = AddSQLStringToDAL.GetDtBySQL(strSql);
//dt.DefaultView.Sort =
gvTeachers.DataSource = dt;
gvTeachers.DataKeyNames = new string[] { "UserID" };
gvTeachers.DataBind();
}
protected void Bind()
{
List <string> str = new List <string>();
str = AddSQLStringToDAL.GetDistinctString("TabTeachers", "Department");
for (int i = 0; i < str.Count; i++)
{
}
}
protected void Bind()
{
List <string> str = new List <string>();
str = AddSQLStringToDAL.GetDistinctString("TabTeachers", "Department");
for (int i = 0; i < str.Count; i++)
{
DropDownList2.Items.Add(str[i].ToString());
}
}
private void InsertTeacherStatus()
{
Clear();
List <string> str = new List <string>();
str = AddSQLStringToDAL.GetDistinctStrings("TabAllCourses", "TeacherID");
lblMessage3.Text = "第一步：教师信息对比完成！正在进行第二步...";
InsertCoursesSimpleMap(str);
lblMessage3.Text = "所有信息核对无误！请对数据进行处理";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Role"].ToString() != "院系领导")
{
Response.Redirect("~\\登录.aspx");
}
else
{
Label1.Visible = false; //多出来的没用
//填充DDL
DataTable DTWeek = AddSQLStringToDAL.GetDataTableBysql("select distinct CurrentWeek from TabTeacherAttendance where [IsAttendance] = '未考勤' and CONVERT(int,CurrentWeek) < '" + Session["CurrentWeek"].ToString() + "' order by CurrentWeek"); //查找小于本周的周次并排序
ddlWeek.Items.Add(Session["CurrentWeek"].ToString());
for (int i = 0; i < DTWeek.Rows.Count; i++)
{
ddlWeek.Items.Add(DTWeek.Rows[i]["CurrentWeek"].ToString());
}
DataTable DTDepartment = AddSQLStringToDAL.GetDataTableBysql("select distinct TeacherDepartment from TabTeacherAttendance");
ddlDepartment.Items.Add("所有系部");
for (int i = 0; i < DTDepartment.Rows.Count; i++)
{
ddlDepartment.Items.Add(DTDepartment.Rows[i]["TeacherDepartment"].ToString());
}
Clear();
DataTable dt1 = GetStudentDt(Session["CurrentWeek"].ToString(), "所有系部");
if (dt1.Rows.Count == 0)
{
lblStudent.Visible = true;
}
else
{
btnStudent.Visible = true;
gvStudent.Visible = true;
gvStudent.DataSource = dt1;
gvStudent.DataBind();
}
DataTable dt2 = GetStudentDt(Session["CurrentWeek"].ToString(), "所有系部");
if (dt2.Rows.Count == 0)
{
lblHomework.Visible = true;
}
else
{
btnHomework.Visible = true;
gvHomework.Visible = true;
gvHomework.DataSource = dt2;
gvHomework.DataBind();
}
}
}
}
protected void btnPrOperation_Click(object sender, EventArgs e)
{
DataTable dt = AddSQLStringToDAL.GetDatatableBySQL("TabTeachers");
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["UserID"].ToString() == dt.Rows[0]["UserPWD"].ToString())
{
initalPWD();
}
}
}
