Admin/BSEdit.aspx.cs

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

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

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_BSEdit : 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");
            if (Request.QueryString["ID"] != null)
            {
                //显示当前的服装信息
                DataTable tmpda = new DataTable();
                tmpda = DataBase.Get_Table("select * from 报损单 where 报损单号='" + Request.QueryString["ID"] + "'");
                if (tmpda.Rows.Count > 0)
                {
                    this.txtCGDH.Text = tmpda.Rows[0]["报损单号"].ToString();
                    this.txtCGSJ.Text = tmpda.Rows[0]["报损时间"].ToString();
                    this.txtCGSL.Text = tmpda.Rows[0]["损失数量"].ToString();
                    this.txtCGJE.Text = tmpda.Rows[0]["损失原因"].ToString();
                    this.drSPXX.SelectedValue = tmpda.Rows[0]["服装代码"].ToString();
                }
            }
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        //根据标志判断是添加还是修改的操作 保存服装信息
        if (Request.QueryString["ID"] != null)
        {
            DataBase.ExecSql("UPDATE [报损单] set [报损时间] ='" + txtCGSJ.Text + "',[服装代码] = " + drSPXX.SelectedValue + ",[损失数量] = " + txtCGSL.Text + ",[损失原因] = '" + txtCGJE.Text + "'  where 报损单号='" + Request.QueryString["ID"] + "'");
        }
        else
        {
            DataBase.ExecSql("INSERT INTO [报损单] ( [报损单号] ,[报损时间] ,[服装代码] ,[损失数量] ,[损失原因] ,[调整库存]  ) VALUES ('" + txtCGDH.Text + "','" + txtCGSJ.Text + "'," + drSPXX.SelectedValue + "," + txtCGSL.Text + ",'" + txtCGJE.Text + "','未调整')");

        }
        Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('保存成功！');window.location.href='BSList.aspx';</script>");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //跳转页面
        Response.Redirect("BSList.aspx");