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

yxj

2021-10-28 80671ec5eca956171492699780d1a3be9d7906d4

 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;
            }
        }




    }

     }
}