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 Manager_EditerNew : System.Web.UI.Page
14...{
15    private int nId;
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (Request.QueryString["Id"] == null)
19        ...{
20
21            Response.Redirect("New.aspx");
22
23        }
24        else ...{
25
26            BindNew();
27        
28        }
29    }
30    protected string IsShow(string isBool)
31    ...{
32
33        string txtRe = string.Empty;
34        if (isBool.ToLower() == "true")
35        ...{
36
37            txtRe = "1";
38
39        }
40        else
41        ...{
42
43            txtRe = "0";
44
45        }
46        return txtRe;
47
48    }
49    protected void BindNew() ...{
50
51        nId = int.Parse(Request.QueryString["Id"].ToString());
52        SqlParameter[] paras =...{ new SqlParameter("Id", SqlDbType.Int, 4) };
53        paras[0].Value = nId;
54        FormViewNew.DataSource = SqlHelper.ExcuteReadApdater("SELECT * FROM [New] WHERE Id=@Id", CommandType.Text, paras);
55        FormViewNew.DataBind();
56    
57    }
58    protected void bnt_Click(object sender, EventArgs e)
59    ...{
60        string txtTitle = ((TextBox)FormViewNew.FindControl("TextBoxTitle")).Text.ToString();
61        int nTypes = int.Parse(((DropDownList)FormViewNew.FindControl("SelectTypes")).SelectedValue.ToString());
62        int nShow = int.Parse(((DropDownList)FormViewNew.FindControl("SelectShow")).SelectedValue.ToString());
63        string txtText = ((TextBox)FormViewNew.FindControl("EditerNew")).Text.ToString();
64        string txtTime = DateTime.Now.ToString();
65        SqlParameter[] paras =...{ new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@Content", SqlDbType.NVarChar,4000), new SqlParameter("@Types", SqlDbType.Bit), new SqlParameter("@NewTime", SqlDbType.DateTime, 8), new SqlParameter("@Vis", SqlDbType.Bit) };
66        paras[0].Value = txtTitle;
67        paras[1].Value = txtText;
68        paras[2].Value = nTypes;
69        paras[3].Value = txtTime;
70        paras[4].Value = nShow;
71        SqlHelper.ExcuteNonQurey("UPDATE [New] SET Name=@Title,Content=@Content,Types=@Types,NewTime=@NewTime,Vis=@Vis", CommandType.Text, paras);
72        Response.Redirect("New.aspx");
73    }
74    protected void ButtonCancel_Click(object sender, EventArgs e) ...{
75
76        Response.Redirect("New.aspx");
77    
78    }
79}
80