protected void btnDelete_Click(object sender, EventArgs e)
{
btnDelete.Attributes.Add("onclick", "return confirm('确定要删除这些老师的记录吗？')");
int m = 0;
Fannie.Teacher t = new Fannie.Teacher();
for (int i = 0; i < gvTeacher.Rows.Count; i++)
{
if (((CheckBox)(gvTeacher.Rows[i].FindControl("cbSelect"))).Checked)
{
t.DeleteOneTea(gvTeacher.DataKeys[i].Value.ToString());
}
else
{
m++;
}
}
if (m == gvTeacher.Rows.Count)
{
Response.Write("<script>alert('请先选择需要删除的记录')</script>");
}
else
{
GetAllTea();
}
}
private void GetMyStu()
{
Fannie.Teacher t = new Fannie.Teacher();
DataSet ds = t.GetMyStu(id);
DataTable dt = new DataTable();
DataColumn dc = new DataColumn();
dc.ColumnName = "AutoId";
ds.Tables[0].Columns.Add(dc);
gvStudent.DataKeyNames = new string[] { "StudentID" };
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["AutoId"] = (i + 1).ToString();
}
gvStudent.DataSource = ds;
gvStudent.DataBind();
dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
Label1.Visible = true;
}
else
{
Label1.Visible = false;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (((Button)(dvTea.FindControl("btnEdit"))).Text == "取消")
{
string id = ((TextBox)(dvTea.FindControl("tbID"))).Text;
string name = ((TextBox)(dvTea.FindControl("tbName"))).Text;
string sex = ((TextBox)(dvTea.FindControl("tbSex"))).Text;
string post = ((TextBox)(dvTea.FindControl("tbPost"))).Text;
string t1 = ((TextBox)(dvTea.FindControl("tbPhone"))).Text;
string t2 = ((TextBox)(dvTea.FindControl("tbTel"))).Text;
string email = ((TextBox)(dvTea.FindControl("tbEmail"))).Text;
string[] pt = new string[7] {
id, name, sex, post, t1, t2, email
};
Fannie.Teacher t = new Fannie.Teacher();
if (t.UpdateOneTea(pt) > 0)
{
Set(true);
((Button)(dvTea.FindControl("btnEdit"))).Text = "编辑";
Response.Write("<script language='javascript'>alert('更新成功！')</script>");
}
}
else
{
Response.Write("<script language='javascript'>alert('请点击编辑，修改信息后再点 更新')</script>");
}
}
private void GetOneTea()
{
Fannie.Teacher t = new Fannie.Teacher();
DataSet ds = t.GetOneTea(id);
dvTea.DataSource = ds;
dvTea.DataBind();
}
private void GetTeacherInfo()
{
Fannie.Teacher t = new Fannie.Teacher();
DataSet ds = t.GetOneTea(id);
dvTea.DataKeyNames = new string[] { "TeacherID" };
dvTea.DataSource = ds;
dvTea.DataBind();
}
private void GetPost() //根据登录id获取教师职称
{
if (tbT1Name.Text.Trim() != "")
{
Fannie.Teacher teacher = new Fannie.Teacher();
DataTable dt = teacher.GetTeacherPost(Request.Cookies["id"].Value.ToString());
tbPost1.Text = dt.Rows[0][0].ToString();
tbPost1.Enabled = false;
}
}
private void GetAllTea()
{
Fannie.Teacher t = new Fannie.Teacher();
DataSet ds = t.GetAllTea();
DataColumn dc = new DataColumn();
dc.ColumnName = "PId";
ds.Tables[0].Columns.Add(dc);
gvTeacher.DataKeyNames = new string[] { "TeacherID" };
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["PId"] = (i + 1).ToString();
}
gvTeacher.DataSource = ds;
gvTeacher.DataBind();
}
private bool IsTime()
{
DateTime dtm = DateTime.Now;
DataTable dt = new DataTable();
Fannie.Teacher tea = new Fannie.Teacher();
dt = tea.GetChooseTime().Tables[0];
DateTime begin = Convert.ToDateTime(dt.Rows[0]["SubjectBegin"].ToString());
DateTime end = Convert.ToDateTime(dt.Rows[0]["SubjectEnd"].ToString());
if (dtm < begin || dtm > end)
{
return(false);
}
else
{
return(true);
}
}
protected void btnTSelect_Click(object sender, EventArgs e)
{
if (tbTID.Text != "")
{
Fannie.Teacher tea = new Fannie.Teacher();
DataSet ds = tea.GetOneTea(tbTID.Text.Trim());
if (ds.Tables[0].Rows.Count == 0)
{
Response.Write("<script>alert('该教师不存在')</script>");
}
else
{
gvTeacher.Visible = true;
gvStudent.Visible = false;
gvTeacher.DataSource = ds;
gvTeacher.DataBind();
}
}
}
protected void btnUpdateClick(object sender, EventArgs e)
{
string name = ((TextBox)(dvTea.FindControl("tbName"))).Text;
string sex = ((TextBox)(dvTea.FindControl("tbSex"))).Text;
string post = ((TextBox)(dvTea.FindControl("tbPost"))).Text;
string t1 = ((TextBox)(dvTea.FindControl("tbT1"))).Text;
string t2 = ((TextBox)(dvTea.FindControl("tbT2"))).Text;
string emai = ((TextBox)(dvTea.FindControl("tbE"))).Text;
object[] obj = new object[7] {
id, name, sex, post, t1, t2, emai
};
Fannie.Teacher t = new Fannie.Teacher();
if (t.UpdateOneTea(obj) > 0)
{
GetOneTea();
Response.Write("<script>alert('修改成功')</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string id = tbNo.Text.Trim();
string name = tbName.Text;
string sex = rblSex.SelectedValue;
string post = ddlPost.SelectedValue;
string t1 = tbPhone.Text;
string t2 = tbTel.Text;
string emai = tbEmail.Text;
object[] obj = new object[7] {
id, name, sex, post, t1, t2, emai
};
Fannie.Teacher t = new Fannie.Teacher();
if (t.InsertOneTea(obj) > 0)
{
Response.Write("<script>alert('成功保存')';location.href='~/Admin/ManageTe.aspx'</script>");
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (fuTea.HasFile)
{
string filename = Server.HtmlEncode(fuTea.FileName);
string extention = Path.GetExtension(filename);
if (extention != ".xls" && extention != ".xlsx")
{
Response.Write("<script>alert('请选择正确的Excel文件!');</script>");
return;
}
string upfilename = "~/DownLoadZone/" + DateTime.Now.ToString("yyyyMMddHHmmss") + extention;
fuTea.SaveAs(Server.MapPath(upfilename));
string ExcelConn = "";
if (extention == ".xls")
{
// Excel 2007以前的版本
ExcelConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(upfilename) + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=2'";
}
else
{
// Excel 2007
ExcelConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(upfilename) + ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=2'";
}
DataTable dt = GetData(ExcelConn);
File.Delete(Server.MapPath(upfilename));
Fannie.Teacher t = new Fannie.Teacher();
if (t.ImportTea(dt))
{
Response.Write("<script>alert('导入成功!');</script>");
}
else
{
Response.Write("<script>alert('导入失败，请检查是否EXCEL按照模版的样式输入数据或者是否有重复的教师工资号');</script>");
}
}
}
protected void gvTeacher_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Fannie.Teacher t = new Fannie.Teacher();
t.DeleteOneTea(gvTeacher.DataKeys[e.RowIndex].Value.ToString());
GetAllTea();
}