Admin/TeacherManage.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using System.IO;
using System.Xml;
public partial class Admin_TeacherManage : BasePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //教师管理提供对教师信息的删除和修改功能
            AllowPage1.ControlID = "GridView2";
            AllowPage1.ControlType = 1;
            AllowPage1.PageSize = 10;
            AllowPage1.SQL = "select tb_url.*,tb_work.wtitle from tb_url,tb_work where tb_url.wid=tb_work.wid and tb_url.state='1'   order by uid desc";
            //AllowPage1.CurrentIndex;
            BindToGrid();
            try
            {
                writeXML();//重写d.xml
            }
            catch
            { }
        }
    }
    public void BindToGrid()
    {
        //AllowPage1.CurrentIndex = 2;
        AllowPage1.DataTbl = SQLClass.Query(AllowPage1.SQL).Tables[0];
        PagedDataSource pds = AllowPage1.GetPagedDataSource(0);
        GridView2.DataSource = pds;
        GridView2.DataKeyNames = new string[] { "uid" };
        GridView2.DataBind();
    }

    protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int uid = Int32.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());
        string sql = "delete from  tb_url where uid=@uid";
        OleDbParameter[] par = new OleDbParameter[1];
        par[0] = new OleDbParameter("@uid", OleDbType.Integer);
        par[0].Value = uid;
        //首先删除教师照片，然后再删除这个教师信息
        string sql1 = "select url from tb_url where uid=" + uid.ToString();

        object obj = SQLClass.GetSingle(sql1);
        if (obj != null)
        {
            if (obj.ToString().Trim() != "no_pic.jpg")