条码异常查询模块新增删除按钮：可删除缓存中未上传条码记录

yxj

2021-10-28 80671ec5eca956171492699780d1a3be9d7906d4

条码异常查询模块新增删除按钮：可删除缓存中未上传条码记录

 SCM/¹«ÓÃÀà/ClsPub1.cs

@@ -15,12 +15,12 @@
        //public static string WEBSURL = "http://122.227.199.62:5050/WMSWEBS/WebService1.asmx";     //韩电    å¤–网              ï¼ˆä½œåºŸï¼‰
        //public static string WEBSURL = "http://192.168.10.60/WMSWEBS/WebService1.asmx";           //韩电    å†…网宁波（车间）（作废）

        //public static string WEBSURL = "http://192.168.2.16/WEBS-WMS/WebService1.asmx";           //颜本地电脑
        public static string WEBSURL = "http://192.168.2.16/WEBS-WMS/WebService1.asmx";           //颜本地电脑
        //public static string WEBSURL = "http://192.168.2.56/WEBS-WMS/WebService1.asmx";           //颜本地电脑（云络）
        //public static string WEBSURL = "http://192.168.10.61/WEB-WMS/WebService1.asmx";           //韩电    å†…网测试


        public static string WEBSURL = "http://192.168.10.222/WMSWEBS/WebService1.asmx";          //韩电    MES服务器（内网）
        //public static string WEBSURL = "http://192.168.10.222/WMSWEBS/WebService1.asmx";          //韩电    MES服务器（内网）
        //public static string WEBSURL = "http://122.227.199.62:5058/WMSWEBS/WebService1.asmx";     //韩电    MES服务器（外网）



 SCM/ÌõÂë´òÓ¡/WMS_BarCodeStatusQuery.cs

@@ -419,9 +419,59 @@
            SCM.公用类.Xt_BaseBillFun.DataToExcel(this.Text, grdMain);
        }

        private void sc_Click(object sender, EventArgs e)
        {
            Sub_DeleteBill();
        }
        //删除
        private void Sub_DeleteBill()
        {
            Int64 lngBillKey = 0;
            string HBarCode = "";
            if (grdMain.CurrentRow == null)
                return;
            if (grdMain.SelectedRows.Count != 1)
            {
                MessageBox.Show("不允许多行删除，请重新选择缓存类型为“缓存”的重复条码！");
                return;
            }

            if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("模块类型")].Value) == "缓存"
                && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("状态")].Value) == "")
            {
                if (MessageBox.Show("确定要删除所选条码记录？删除后不能恢复，请谨慎操作！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[0].Cells[Fun_GetCol("HitemID")].Value);
                    HBarCode = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("单据类型")].Value)+ DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("单据号")].Value)+"，条码："+ DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("条形码")].Value);
                    if (lngBillKey == 0)
                        return;

                    try
                    {
                        string[] sSQLMul = new string[2];
                        sSQLMul[0] = "Delete from KF_PonderationBillMain_Temp where  HRelationInterID=0 and HitemID =" + lngBillKey;
                        sSQLMul[1] = "Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','删除缓存中异常重复条码：" + HBarCode + "','WMS系统-条码异常查询模块','" + DBUtility.ClsPub.IPAddress + "','删除'";

                        oWeb.getRunProcByMul(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);
                        MessageBox.Show("缓存列表，" + HBarCode + " è®°å½•åˆ é™¤æˆåŠŸï¼");
                        Display();
                    }
                    catch (Exception e)
                    {
                        throw (e);
                    }
                }
            }
            else
            {
                MessageBox.Show("只允许删除模块类型为“缓存”，状态不为“已上传”条码记录！");
                return;
            }
        }




    }

     }
}

 SCM/ÌõÂë´òÓ¡/WMS_BarCodeStatusQuery.designer.cs

@@ -45,6 +45,7 @@
            this.dy2 = new System.Windows.Forms.ToolStripButton();
            this.yl = new System.Windows.Forms.ToolStripButton();
            this.yc = new System.Windows.Forms.ToolStripButton();
            this.dc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.sx = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
@@ -61,7 +62,8 @@
            this.grdPrint = new System.Windows.Forms.DataGridView();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.dc = new System.Windows.Forms.ToolStripButton();
            this.sc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.Tool.SuspendLayout();
@@ -179,6 +181,8 @@
            this.yl,
            this.yc,
            this.dc,
            this.toolStripSeparator4,
            this.sc,
            this.toolStripSeparator2,
            this.sx,
            this.toolStripSeparator1,
@@ -269,6 +273,21 @@
            this.yc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.yc.Click += new System.EventHandler(this.yc_Click);
            // 
            // dc
            // 
            this.dc.AutoSize = false;
            this.dc.Image = ((System.Drawing.Image)(resources.GetObject("dc.Image")));
            this.dc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dc.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.dc.Name = "dc";
            this.dc.Size = new System.Drawing.Size(36, 47);
            this.dc.Text = "导出";
            this.dc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dc.ToolTipText = "导出";
            this.dc.Click += new System.EventHandler(this.dc_Click);
            // 
            // toolStripSeparator2
            // 
@@ -383,10 +402,10 @@
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1011, 397);
            this.grdMain.TabIndex = 19;
            this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp);
            this.grdMain.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.grdMain_CellBeginEdit);
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp);
            this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged);
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            // 
            // grdPrint
            // 
@@ -423,20 +442,24 @@
            this.grdSum.Size = new System.Drawing.Size(1011, 19);
            this.grdSum.TabIndex = 52;
            // 
            // dc
            // sc
            // 
            this.dc.AutoSize = false;
            this.dc.Image = ((System.Drawing.Image)(resources.GetObject("dc.Image")));
            this.dc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dc.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.dc.Name = "dc";
            this.dc.Size = new System.Drawing.Size(36, 47);
            this.dc.Text = "导出";
            this.dc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dc.ToolTipText = "导出";
            this.dc.Click += new System.EventHandler(this.dc_Click);
            this.sc.AutoSize = false;
            this.sc.Image = ((System.Drawing.Image)(resources.GetObject("sc.Image")));
            this.sc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.sc.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.sc.Name = "sc";
            this.sc.Size = new System.Drawing.Size(36, 47);
            this.sc.Text = "删除";
            this.sc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.sc.Click += new System.EventHandler(this.sc_Click);
            // 
            // toolStripSeparator4
            // 
            this.toolStripSeparator4.Name = "toolStripSeparator4";
            this.toolStripSeparator4.Size = new System.Drawing.Size(6, 50);
            // 
            // WMS_BarCodeStatusQuery
            // 
@@ -500,5 +523,7 @@
        private System.Windows.Forms.ToolStripButton yc;
        private System.Windows.Forms.DataGridView grdSum;
        private System.Windows.Forms.ToolStripButton dc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator4;
        private System.Windows.Forms.ToolStripButton sc;
    }
}

 SCM/ÌõÂë´òÓ¡/WMS_BarCodeStatusQuery.resx

@@ -112,12 +112,12 @@
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <data name="pPic.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        Qk22QAMAAAAAADYAAAAoAAAAFQMAAFoAAAABABgAAAAAAAAAAADDDgAAww4AAAAAAAAAAAAA////////
@@ -3675,7 +3675,7 @@
        //////////////////////////////////////////////////////////////////////8A
</value>
  </data>
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </metadata>
  <data name="Tool.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
@@ -3987,6 +3987,20 @@
        GVBMzd06lBMH0E0aik5mFOUC7257TWMZuJgAAAAASUVORK5CYII=
</value>
  </data>
  <data name="sc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAG5SURBVDhPlZDrK4NhGMafP8BHf4BPwkfmq8NnvhKlUHxw
        iEgSIsQKqcVyPjQ2Z9mS0ooSlqElQ07RaGRib6zmeHmf27O3zSZcdbXnfp77+r33PRZKZdXN8Le4/pt4
        wO15g0vykvn5V4j/1/5iEfsSv/iPbPbjQAgvHp5ecXrlwv6ZE7bDC1h2j7BitWNpzYZ5swUG0zL6Jxag
        GZxCe68+GFBe14rjkzOMjs9iSD+DPt0ktAN6dHQPQ63pR0N7N+pbtdBNL6KmRRNijVo1jWexHcLjfcbN
        gwcDBhOOzp0wW+zoGpmG0bxBE1U2tAX/ocWVjQRY27JDenzClUtC39g8Dk4dcFzf0RuXw+nC+uZOMKCg
        vI4avgPupUfg4wPWaEb2yVeLOGN5JVX08B3ARcFt+SBbAfnVBMgprKDmUIBOJgeaIr4sgr6avxEgK7+U
        mkOuIIsgxeEBVsJcGblF1PgTgMZODQuwMj5XenYBNa5a9+CWAZe3bvTo5uhO2Zn/xgmLOwWSKSbg8r4D
        954XXNxIVNP4IszPVAtIwBrJKWmIjE1AlCoR0aokxMQnYWLGqEAoKIv3+mrGGPsEfOpdAqh7YNYAAAAA
        SUVORK5CYII=
</value>
  </data>
  <data name="sx.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
@@ -4041,13 +4055,13 @@
        AAAASUVORK5CYII=
</value>
  </data>
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>102, 16</value>
  </metadata>
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>191, 16</value>
  </metadata>
  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>37</value>
  </metadata>
</root>