maiAdd.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class maiAdd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.txt_tel.Text = Session["tel"].ToString();
            this.dizhi.Items.Add(Session["address"].ToString());
            DataSet ds = DbHelperSQL.Query("select * from dizhi where xuehao='" + Session["lname"].ToString() + "'");
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++) 
            {
                this.dizhi.Items.Add(ds.Tables[0].Rows[0]["dizhi"].ToString());
            }
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string mingcheng = this.mingcheng.Text;
        string dizhi = this.dizhi.Text;
        string dianhua = this.txt_tel.Text;
        string beizhu = this.beizhu.Text;
        string feiyong = this.feiyong.Text;
        string strsql = " Insert into maiOrder(mingcheng,dizhi,dianhua,beizhu,shijian,feiyong,xuehao) values";
        strsql += "('" + mingcheng + "','" + dizhi + "','" + dianhua + "','" + beizhu + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "'," + feiyong + ",'"+Session["lname"].ToString()+"')";
        int n = DbHelperSQL.ExecuteSql(strsql);
        if (n > 0) 
        {
            MessageBox.ShowAndRedirect(this, "发布成功！", "maiAdd.aspx");
        }
    }
}