stock/stockmod.aspx.cs

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

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

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 stock_stockmod : System.Web.UI.Page
{
    string id = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        id = Request.QueryString["id"].ToString();
        if (!IsPostBack)
        {

            string sql = "select * from stock where id='" + id + "'";
            DataTable dt = DBHelper.GetDataSet(sql);
            if (dt.Rows.Count > 0)
            {
               this.commodityid.Text =dt.Rows[0]["commodityid"].ToString();
this.companyid.Text =dt.Rows[0]["companyid"].ToString();
this.number.Text =dt.Rows[0]["number"].ToString();
this.pirce.Text =dt.Rows[0]["pirce"].ToString();
this.stockdate.Text =dt.Rows[0]["stockdate"].ToString();
this.payment.Text =dt.Rows[0]["payment"].ToString();
this.factpayment.Text =dt.Rows[0]["factpayment"].ToString();
this.notpayment.Text =dt.Rows[0]["notpayment"].ToString();
this.manageman.Text =dt.Rows[0]["manageman"].ToString();
this.username.Text =dt.Rows[0]["username"].ToString();
this.addTime.Text =dt.Rows[0]["addTime"].ToString();


     
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      string commodityid=this.commodityid.Text;//商品号
string companyid=this.companyid.Text;//供应商号
string number=this.number.Text;//商品数量
string pirce=this.pirce.Text;//商品单价
string stockdate=this.stockdate.Text;//进货日期
string payment=this.payment.Text;//应付金额
string factpayment=this.factpayment.Text;//实付金额
string notpayment=this.notpayment.Text;//未付金额
string manageman=this.manageman.Text;//经手员工
string username=this.username.Text;//操作人员
string addTime=this.addTime.Text;//修改时间

		
     
        string sql = "update stock set  commodityid='"+commodityid+"',companyid='"+companyid+"',number='"+number+"',pirce='"+pirce+"',stockdate='"+stockdate+"',payment='"+payment+"',factpayment='"+factpayment+"',notpayment='"+notpayment+"',manageman='"+manageman+"',username='"+username+"',addTime='"+addTime+"' where id ='"+id+"'";