System/ProductRuKu.aspx.cs

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

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

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;
using System.Data.SqlClient;

public partial class System_ProductRuKu : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DB.Bind_Dropdownlist("select * from product", ddlProduct, "productid", "productname");
            DB.Bind_Dropdownlist("select * from [class]", ddlClass, "classid", "classname");
        }
    }

    /// <summary>
    /// 按钮事件：提交信息
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {
            string sql2 = string.Empty;

            DataTable dt = DB.getDataTable("select * from Storage where ClassId=" + ddlClass.SelectedValue + " and ProductId=" + ddlProduct.SelectedValue + " and EndTime='" + txtendTime.Text.Trim() + "'");
            if (dt.Rows.Count <= 0)//添加
            {
                sql2 = "insert into Storage(ClassId,ProductId,EndTime,Num) ";
                sql2 += "values('" + ddlClass.SelectedValue + "','" + ddlProduct.SelectedValue + "','" + txtendTime.Text.Trim() + "','" + txtnum.Text.Trim() + "')";
            }
            else//修改
            {
                sql2 = "update Storage set Num={0} where ClassId=" + ddlClass.SelectedValue + " and ProductId=" + ddlProduct.SelectedValue + " and EndTime='" + txtendTime.Text.Trim() + "'";
                sql2 = string.Format(sql2, Convert.ToInt32(dt.Rows[0]["num"]) + Convert.ToInt32(txtnum.Text.Trim()));
            }

            SqlConnection cn = DB.OpenConnection();
            SqlCommand cmd = new SqlCommand(sql2, cn);
            cmd.ExecuteNonQuery();
            cn.Close();
            cn.Dispose();
            Common.ShowMessage(this.Page, "产品入库成功！", "", "StorageList.aspx");
        }
        catch (Exception ex)
        {
            Common.ShowMessage(this.Page, "信息保存失败，请稍后重试。" + ex.Message, "");
            return;
        }
    }