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;
12
13public partial class BackAdmin_SettleProject_InsertSettleProject : System.Web.UI.Page
14...{
15    CAN can = new CAN();
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        TextBox1.Text = Session["Name"].ToString();
19
20        if (Page.IsPostBack == false)
21        ...{
22            this.TextBox3.Visible = false;
23            SqlConnection myconnection = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
24            myconnection.Open();
25            SqlDataAdapter myadapter = new SqlDataAdapter("select * from tb_regimentation ORDER BY ID DESC", myconnection);
26            DataSet mydataset = new DataSet();
27            myadapter.Fill(mydataset);
28            DropDownList1.DataSource = mydataset;
29            DropDownList1.DataTextField = "Name";
30            DropDownList1.DataValueField = "id";
31            DropDownList1.DataBind();
32
33            SqlCommand mycom = new SqlCommand("select id from tb_Administrator where Name='" + Session["Name"].ToString() + "'",myconnection);
34            Session["userid"] = Convert.ToInt32(mycom.ExecuteScalar());
35            myconnection.Close();   
36        }
37    }
38    protected void btninsert_Click(object sender, EventArgs e)
39    ...{
40        //--------------------------------------------------------------------------------------------------------------
41        //                         执行文件上传至服务器
42        string filePath = "", fileExtName = "", mFileName, mPath;
43        if ("" != this.File1.PostedFile.FileName)
44        ...{
45            filePath = File1.PostedFile.FileName;
46            fileExtName = filePath.Substring(filePath.LastIndexOf(".") + 1);
47            try
48            ...{
49                mPath = Server.MapPath("../../SettTmg/");
50                mFileName = filePath.Substring(filePath.LastIndexOf("\\") + 1);
51                File1.PostedFile.SaveAs(mPath + mFileName);
52                TextBox3.Text = "SettTmg/" + mFileName;
53                //TextBox3.Text = mFileName;//只将文件名存入数据库中
54                File1.Visible = false;
55                TextBox3.Visible = true;
56            }
57            catch (Exception err)
58            ...{
59                Response.Write(err.ToString());
60            }
61        }
62        //---------------------------------------------------------------------------------------------------------------
63            //SqlConnection mycon = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
64            //mycon.Open();
65            //string SqlStr = "insert into tb_SettleProject(Name,regimentationID,person,img,content)values('" + txtRegimentationname.Text + "','" + DropDownList1.Text + "','" + Session["userid"].ToString() + "','" + TextBox3.Text + "','" + TextBox2.Text + "')";
66            //SqlCommand mycom = new SqlCommand(SqlStr, mycon);
67            //mycom.ExecuteNonQuery();
68            //mycom.Dispose();
69            //mycon.Close();
70        can.ExecSqlCom("insert into tb_SettleProject(Name,regimentationID,person,img,content)values('" + txtRegimentationname.Text + "','" + DropDownList1.Text + "','" + Session["userid"].ToString() + "','" + TextBox3.Text + "','" + TextBox2.Text + "')");
71        Response.Write("<script lanuage=javascript>alert('添加成功！');location='SettleProject.aspx'</script>");
72    }
73    protected void Button1_Click(object sender, EventArgs e)
74    ...{
75        Page.Response.Redirect("SettleProject.aspx");
76    }
77    protected void Button2_Click(object sender, EventArgs e)
78    ...{
79    }
80}
81