admin/add_WSDC.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class admin_add_WSDC : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["users"] == null)
            {
                MessageBox.ShowAndRedirect(this.Page, "对不起！您还没有登录系统。", "loginout.aspx");
            }
            if (Request["id"] != null)
            {

                string sql = "select * from ZXDC where id=@id";
                SqlParameter[] para = new SqlParameter[] { 
                    new SqlParameter("@id",int.Parse(Request["id"].ToString()))
                    };
                DataSet set = DBClass.GetTableDataCan(sql, "sql", para);
                title.Text = set.Tables["sql"].Rows[0]["title"].ToString();
                Ktime.Text = set.Tables["sql"].Rows[0]["Ktime"].ToString();
                Stime.Text = set.Tables["sql"].Rows[0]["Stime"].ToString();
                FCKeditor1.Value = set.Tables["sql"].Rows[0]["content"].ToString().Replace("'", "*");
             
                Button2.Visible = true;
                Button1.Visible = false;

                Littype.Text = "修改网上调查";

            }
            else
            {

                Littype.Text = "添加网上调查";
                Ktime.Text = DateTime.Now.ToString("yyyy-MM-dd");
                Stime.Text = DateTime.Now.AddYears(1).ToString("yyyy-MM-dd");
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "insert into ZXDC(title,Ktime,Stime,content) values(@title,@Ktime,@Stime,@content)";
        SqlParameter[] para = new SqlParameter[] { 
        new SqlParameter("@title",title.Text.Trim()), 
        new SqlParameter("@Ktime",Ktime.Text.Trim()),          
        new SqlParameter("@Stime",Stime.Text.ToString()),
        new SqlParameter("@content",FCKeditor1.Value.ToString())         
            };
        if (DBClass.ExecuteNonQueryCan(sql, para))