Admin/XSDEdit.aspx.cs

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

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

public partial class Admin_XSDEdit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        if (!Page.IsPostBack)
        {
            //绑定类别列表
            this.drSPXX.DataTextField = "信息";
            this.drSPXX.DataValueField = "代码";
            this.drSPXX.DataSource = DataBase.Get_Table("select * from V_服装");
            this.drSPXX.DataBind();
            this.txtCGDH.Text = DateTime.Now.ToString("yyyyMMddHHmmss");
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strMsg = DataBase.RemoveKCXX(Convert.ToDecimal(drSPXX.SelectedValue), Convert.ToDecimal(txtCGSL.Text));
        if (strMsg != "OK")
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('" + strMsg + "');</script>");
            return;
        }
        //根据标志判断是添加还是修改的操作 保存服装信息
       DataBase.ExecSql("INSERT INTO [销售单] ( [销售单号] ,[销售时间] ,[服装代码] ,[销售数量] ,[销售金额] ,[销售单价] ,[客户信息] ) VALUES ('" + txtCGDH.Text + "','" + txtCGSJ.Text + "'," + drSPXX.SelectedValue + "," + txtCGSL.Text + "," + txtCGJE.Text + ","+txtXSDJ.Text+",'" + txtCGSXX.Text + "')");
       Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('销售完毕！');window.location.href='XSDList.aspx';</script>");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //跳转页面
        Response.Redirect("XSDList.aspx");
    }
}