info_add.aspx.cs

一个简单的聊天代码

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;

public partial class admin_addinfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        { pmll(); }
    }
    /// <summary>
    /// 
    /// </summary>
    /// <param name="name"></param>
    /// <param name="Sc">已经选择项</param>
    /// <returns></returns>
    public string Mystr(string name,string Sc)
    {
        string s = "<select name='"+name+"'>";
        DataTable dt = Spbase.GreatDs("Select * from Spclass").Tables[0];

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            if (Sc == dt.Rows[i]["ID"].ToString())
            {
                s += "<option selected=true value='" + dt.Rows[i]["ID"].ToString() + "'>" + dt.Rows[i]["name"].ToString() + "</option>";
            }
            else
            {
                s += "<option  value='" + dt.Rows[i]["ID"].ToString() + "'>" + dt.Rows[i]["name"].ToString() + "</option>";
            
            }
        }
        s += "</select> ";
        return s;
    }
     void pmll()
    {   string id=spstr.tosql(Request.QueryString["id"]);
        string sql;
        sql = "select * from info where id="+id;
        DataSet sm= Spbase.GreatDs(sql);
        Repeater1.DataSource = sm;
        Repeater1.DataBind();
    }

    
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Request.QueryString["id"] != null)
        { HtmlInputFile File2=new HtmlInputFile();
        File2 = (HtmlInputFile)Repeater1.Items[0].FindControl("File2");
            string attribute, sort, title, usertext, linkman, phone, email, adress, period, say,dtt, jb, iid, dq, xdq,images;
            attribute = Request.Form["cshangqsx"];
            sort = Request.Form["Mysort"];
            title = Request.Form["biaoti"];
            usertext = Request.Form["neirong"];
            linkman = Request.Form["lianxiren"];
            phone = Request.Form["dianhua"];
            email = Request.Form["youjian"];
            adress = Request.Form["dizhi"];
            period = Request.Form["yxq"];
            say = Request.Form["shuoming"];
            dtt = DateTime.Now.ToString();
            jb = Request.Form["cleib"];
            iid = spstr.tosql(Request.QueryString["id"]);
            xdq = Request.Form["cleibgg"];
            dq = System.DateTime.Now.AddDays(Convert.ToInt32(xdq)).ToString();
            Sp.Up_Loadcs up = new Sp.Up_Loadcs();
            string Res = up.Up(File2, "../images/upimages/");
            Response.Write(up.Resup[Convert.ToInt32(Res)]);
            images = up.s;
            string sql = "update info set attribute='" + attribute + "',sort=" + sort + ",title='" + title + "',usertext='" + usertext + "', linkman='" + linkman + "',phone='" + phone + "',email='" + email + "', adress='" + adress + "',period='" + period + "', say='" + say + "', dtt=#" + dtt + "#,jb=" + jb + ", dq=#" + dq + "#,images='"+images+"' where id=" + iid;
          
            Spbase.DoSql(sql);
            Sp.MessageBox.Show(this.Page, "修改成功！");
            pmll();
        }
    }
}