jinhuo/jinhuoadd.aspx.cs

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
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;
using System.Xml.Linq;
using dao;
public partial class jinhuo_jinhuoadd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string spid = this.spid.SelectedValue.ToString();
        string sl = this.sl.Text;
        string crz = this.czr.Text;
        string sj = System.DateTime.Now.ToString();
       
        if (spid.Length == 0)
        {
            MessageBox.Show(this.Page, "商品不能为空");
            return;
        }
        if (sl.Length == 0)
        {
            MessageBox.Show(this.Page, "数量不能为空");
            return;
        }
        if (crz.Length == 0)
        {
            MessageBox.Show(this.Page, "操作人不能为空");
            return;
        }
        int row = 0; 
        string sql = "insert into jinhuo(spid,sl,czr,sj) values('" + spid + "','" + sl + "','" + crz + "','" + sj + "')";
        try
        {
            row = DBHelper.ExecuteCommand(sql);
            sql = "update shangpin set sl=sl+"+sl+" where spid='"+spid+"'";
            row = DBHelper.ExecuteCommand(sql);
        }
        catch (Exception ex)
        {
            MessageBox.ShowAndRedirect(this.Page, ex.Message, "jinhuoadd.aspx");

        }
        MessageBox.ShowAndRedirect(this.Page, "进货登记成功", "jinhuoadd.aspx");
    }
}