1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12using System.IO;
13
14public partial class BackAdmin_AdminSoftwareInfo : System.Web.UI.Page
15...{
16    CAN can = new CAN();
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        can.ExecAdapterBindInfoString(GridView1, "select * from SoftView ORDER BY ID DESC", "id");
20    }
21    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
22    ...{
23        GridView1.PageIndex = e.NewPageIndex;
24        GridView1.DataBind();
25    }
26    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
27    ...{
28        SqlConnection con = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
29        con.Open();
30        SqlDataAdapter ada = new SqlDataAdapter("select * from tb_SoftwareInfo where ID='" + this.GridView1.DataKeys[e.RowIndex].Value.ToString() + "'", con);
31        DataSet ds = new DataSet();
32        ada.Fill(ds, "tb_SoftwareInfo");
33        DataRow[] row = ds.Tables[0].Select();
34        foreach (DataRow rs in row)  //将检索到的数据逐一,循环添加到Listbox1中
35        ...{
36            if (rs["interface"].ToString() != "")
37            ...{
38                FileInfo file = new FileInfo(Server.MapPath("../../" + rs["interface"].ToString()));
39                file.Delete();
40
41            }
42            if (rs["UpFileServerLoad"].ToString() != "")
43            ...{
44                FileInfo file1 = new FileInfo(Server.MapPath("../../" + rs["UpFileServerLoad"].ToString()));
45                file1.Delete();
46
47            }
48        }
49        SqlConnection myconnection = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
50        myconnection.Open();
51        SqlCommand mycommand = new SqlCommand("delete from tb_SoftwareInfo where id='" + GridView1.DataKeys[e.RowIndex].Value + "'", myconnection);
52        mycommand.ExecuteNonQuery();
53        SqlDataAdapter myadapter = new SqlDataAdapter("select * from SoftView ORDER BY ID DESC", myconnection);
54        DataSet myset = new DataSet();
55        myadapter.Fill(myset);
56        GridView1.DataSource = myset;
57        GridView1.DataBind();
58        myconnection.Close();
59
60    }
61    protected void LinkButton1_Click(object sender, EventArgs e)
62    ...{
63        Page.Response.Redirect("InsertAdminSoftwareInfo.aspx");
64    }
65    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
66    ...{
67        if (e.Row.RowType == DataControlRowType.DataRow)
68        ...{
69            ((LinkButton)(e.Row.Cells[8].Controls[0])).Attributes.Add("onclick", "return confirm('确定删除吗？')");
70            e.Row.Cells[0].Text = can.SubStr(e.Row.Cells[0].Text.ToString(), 4);
71        }
72    }
73}
74