当前文件： EduMis/EduAdmin/Admin_News_add.aspx.cs[2K，2009-6-12 11:41:43]，打开代码结构图

		            
 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.Common;
12using EduMIScnCommon;
13
14public partial class News_Admin_News_add : System.Web.UI.Page
15...{
16    Database MyEduDataBase = DatabaseManager.CreateDatabase("EduMISConnStr");
17
18    protected void Page_Load(object sender, EventArgs e)
19    ...{
20        DataSet ds = MyEduDataBase.ExecuteDataSet("select * from EduMIS_News_CatLists where News_C_ID<>1 order by News_C_Order desc,News_C_ID desc");
21        News_ClassID.DataSource = ds;
22        News_ClassID.DataBind();
23
24        DataSet ds2 = MyEduDataBase.ExecuteDataSet("select * from EduMIS_News_SpeLists  order by News_SP_Order desc,News_SP_ID desc");
25        News_SpecialID.DataSource = ds2;
26        News_SpecialID.DataBind();
27
28        News_WriteTime.Text = System.DateTime.Now.ToString();
29
30    }
31    protected void Button1_Click(object sender, EventArgs e)
32    ...{
33        string N_ID = News_ClassID.SelectedValue.ToString();
34        string N_SID = News_SpecialID.SelectedValue.ToString();
35        string N_TITLE = News_title.Text;
36        string N_CON = new Common().GetText(News_content.Text);
37        string N_AUTHOR = News_Author.Text;
38        string N_TIME = News_WriteTime.Text;
39        string N_FROM = News_ComeFrom.Text;
40        string N_PIC = News_UploadImage.Text;
41        string N_IP = Page.Request.UserHostAddress.ToString();
42
43        string StrSQL = "INSERT INTO EduMIS_News ";
44        StrSQL = StrSQL + "(News_ClassID,News_SpecialID,News_title,News_content,News_Author,News_WriteTime,News_ComeFrom,News_IP,News_isTop,News_isBest,News_isAccept,News_UploadImage,News_isPic) ";
45        StrSQL = StrSQL + " VALUES ";
46        StrSQL = StrSQL + "(" + N_ID + "," + N_SID + ",'" + N_TITLE + "','" + N_CON + "','" + N_AUTHOR + "','" + N_TIME + "','" + N_FROM + "','" + N_IP + "'," + News_isTop.Checked + "," + News_isBest.Checked + "," + News_isAccept.Checked + ",'" + N_PIC + "'," + News_isPic.Checked + ") ";
47        MyEduDataBase.ExecuteNonQuery(StrSQL);
48        WebHelper.AlertAndRedirect("信息添加成功！", "Admin_News_Default.aspx?ID=1");
49    }
50}
51