条码档案列表打印时条码打印次数更新，删除、批删功能修改

yxj

2021-10-11 4fb24006922163b2b5b580460ef7367920a01935

条码档案列表打印时条码打印次数更新，删除、批删功能修改

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

@@ -1774,7 +1774,7 @@
                if (oWeb.getRunProcByMul_Back(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //将条码存入条码打印次数记录表中
                    oWeb.getRunProc("insert into Gy_BarCodeBill_PrintQty (HBarCodeItemID,HBarCodeInterID,HBarCode,HPrintQty) select HItemID,HInterID,HBarCode,0 from Gy_BarCodeBill where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oWeb.getRunProc("insert into Gy_BarCodeBill_PrintQty (HBarCodeItemID,HBarCodeInterID,HBarCodeType,HBarCode,HPrintQty) select HItemID,HInterID,HBarCodeType,HBarCode,0 from Gy_BarCodeBill where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    MessageBox.Show("条码生成完毕！");

                    ////查询最后一行条码是否存在于条码档案表中

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

@@ -170,59 +170,98 @@
                MessageBox.Show("您没有删除权限！");
                return;
            }
            DataSet DS;
            DataSet DS2;
            bool sBool = true;
            Int64 lngBillKey = 0;
            string HBarCode = "";
            if (grdMain.CurrentRow == null)
                return;
            if (MessageBox.Show("确定要删除所选单据？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            if (grdMain.SelectedRows.Count != 1)
            {
                for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
                MessageBox.Show("不允许多行删除，请重新选择要删除的条码！");
                return;
            }

            if (MessageBox.Show("确定要删除所选条码？删除后不能恢复，请谨慎操作！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[0].Cells[Fun_GetCol("hmainid")].Value);
                HBarCode = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("条码编号")].Value);
                if (lngBillKey == 0)
                    return;
                try
                {
                    lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
                    if (lngBillKey == 0)
                    DataSet DS = oWeb.getDataSetBySQL("exec h_p_Gy_BarCodeBill_Delete " + lngBillKey + ",'" + HBarCode + "','" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_Delete", ref DBUtility.ClsPub.sExeReturnInfo);

                    if (DS == null || DS.Tables[0].Rows.Count <= 0)
                    {
                        MessageBox.Show("删除失败！");
                        return;
                    try
                    {
                        DS = oWeb.getDataSetBySQL("Select * from Gy_BarCodeBill Where HItemID=" + lngBillKey, "Gy_BarCodeBill", ref DBUtility.ClsPub.sExeReturnInfo);
                        DS2 = oWeb.getDataSetBySQL("Select * from Gy_BarCodeBill a inner join Kf_ICStockBillSub_WMS b on a.HBarCode=b.HBarCode where a.HItemID=" + lngBillKey, "Gy_BarCodeBill", ref DBUtility.ClsPub.sExeReturnInfo);
                        if (DS2.Tables[0].Rows.Count == 0)
                        {
                            sBool = false;
                        }
                        else
                        {
                            sBool = true;
                        }
                        if (DS.Tables[0].Rows.Count == 0)
                        {
                            MessageBox.Show("单据未找到！", "提示");
                            return;
                        }
                        else
                        {
                            if (sBool)
                            {
                                MessageBox.Show("删除失败，条码" + grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value + "已被使用", "提示");
                                Display();
                                return;
                            }
                            else
                            {
                                oWeb.getRunProc("Delete from Gy_BarCodeBill where HItemID=" + lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo);
                                oWeb.getRunProc("insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除条码：" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value) + "' ,'WMS系统','','删除')", ref DBUtility.ClsPub.sExeReturnInfo);
                            }
                        }
                    }
                    catch (Exception e)
                    else
                    {
                        throw (e);
                        MessageBox.Show(DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]));
                        Display();
                    }
                }
                catch (Exception e)
                {
                    throw (e);
                }
            }
            MessageBox.Show("删除成功！", "提示");
            Display();


            //原先删除条码方法
            //DataSet DS;
            //DataSet DS2;
            //bool sBool = true;
            //Int64 lngBillKey = 0;
            //if (grdMain.CurrentRow == null)
            //    return;
            //if (MessageBox.Show("确定要删除所选单据？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            //{
            //    for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
            //    {
            //        lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
            //        if (lngBillKey == 0)
            //            return;
            //        try
            //        {
            //            DS = oWeb.getDataSetBySQL("Select * from Gy_BarCodeBill Where HItemID=" + lngBillKey, "Gy_BarCodeBill", ref DBUtility.ClsPub.sExeReturnInfo);
            //            DS2 = oWeb.getDataSetBySQL("Select * from Gy_BarCodeBill a inner join Kf_ICStockBillSub_WMS b on a.HBarCode=b.HBarCode where a.HItemID=" + lngBillKey, "Gy_BarCodeBill", ref DBUtility.ClsPub.sExeReturnInfo);
            //            if (DS2.Tables[0].Rows.Count == 0)
            //            {
            //                sBool = false;
            //            }
            //            else
            //            {
            //                sBool = true;
            //            }
            //            if (DS.Tables[0].Rows.Count == 0)
            //            {
            //                MessageBox.Show("单据未找到！", "提示");
            //                return;
            //            }
            //            else
            //            {
            //                if (sBool)
            //                {
            //                    MessageBox.Show("删除失败，条码" + grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value + "已被使用", "提示");
            //                    Display();
            //                    return;
            //                }
            //                else
            //                {
            //                    oWeb.getRunProc("Delete from Gy_BarCodeBill where HItemID=" + lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo);
            //                    oWeb.getRunProc("insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除条码：" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value) + "' ,'WMS系统','','删除')", ref DBUtility.ClsPub.sExeReturnInfo);
            //                }
            //            }
            //        }
            //        catch (Exception e)
            //        {
            //            throw (e);
            //        }
            //    }
            //}
            //MessageBox.Show("删除成功！", "提示");
            //Display();
        }


@@ -235,26 +274,68 @@
                MessageBox.Show("您没有删除权限！");
                return;
            }
            DataSet DS;
            DataSet DS2;
            bool sBool = true;
            Int64 lngBillKey = 0;
            if (grdMain.SelectedRows == null)
            string HItemID = "";
            string HBarCode = "";
            string HRemark = "";
            if (grdMain.CurrentRow == null)
                return;
            if (MessageBox.Show("确定要批量删除所选单据？删除后不能恢复，请谨慎操作", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)

            if (MessageBox.Show("确定要批量删除所选条码？删除后不能恢复，请谨慎操作！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                string[] sSQLMul = new string[grdMain.SelectedRows.Count];
                for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
                for (int i = 0; i < grdMain.SelectedRows.Count; i++)
                {
                    lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
                    sSQLMul[i] = " Delete from Gy_BarCodeBill where HItemID= " + lngBillKey ;
                    sSQLMul[i] = sSQLMul[i] + "  " + "insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除条码：" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value) + "' ,'WMS系统','','删除')";
                    HItemID = HItemID + "," + DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value.ToString());
                    HBarCode = HBarCode + "," + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value);

                    if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("成品入库日期")].Value)!=""
                        || DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("生产汇报日期")].Value) != "")
                    {
                        HRemark = HRemark + "," + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value);
                    }
                }

                oWeb.getRunProcByMul(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);
                if (HRemark!="")
                {
                    MessageBox.Show("条码编号："+ HRemark.Remove(0, 1) + "，已被使用，不允许删除！");
                    return;
                }
                try
                {
                    HItemID = HItemID.Remove(0, 1);
                    HBarCode = HBarCode.Remove(0, 1);
                    oWeb.getRunProc("Delete from Gy_BarCodeBill where HItemID in (" + HItemID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                    oWeb.getRunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','批量删除条码：" + HBarCode + "','WMS系统-条码档案列表模块','" + DBUtility.ClsPub.IPAddress + "','删除'", ref DBUtility.ClsPub.sExeReturnInfo);
                    MessageBox.Show("条码编号：" + HBarCode + "，批量删除成功！");
                    Display();
                }
                catch (Exception e)
                {
                    throw (e);
                }
            }
            MessageBox.Show("批量删除成功！", "提示");
            Display();


            ////原先批量删除条码方法
            //DataSet DS;
            //DataSet DS2;
            //bool sBool = true;
            //Int64 lngBillKey = 0;
            //if (grdMain.SelectedRows == null)
            //    return;
            //if (MessageBox.Show("确定要批量删除所选单据？删除后不能恢复，请谨慎操作", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            //{
            //    string[] sSQLMul = new string[grdMain.SelectedRows.Count];
            //    for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++)
            //    {
            //        lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value);
            //        sSQLMul[i] = " Delete from Gy_BarCodeBill where HItemID= " + lngBillKey ;
            //        sSQLMul[i] = sSQLMul[i] + "  " + "insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除条码：" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条码编号")].Value) + "' ,'WMS系统','','删除')";
            //    }

            //    oWeb.getRunProcByMul(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);
            //}
            //MessageBox.Show("批量删除成功！", "提示");
            //Display();
        }

        private void timer2_Tick(object sender, EventArgs e)
@@ -398,6 +479,7 @@

        GridppReport Report;
        string sBarCode = "";
        string sBarCodeItemID = "";

        //预览
        int CurRows = 0;
@@ -432,10 +514,12 @@
        private bool ReportPrintBegin()
        {
            sBarCode = "";
            sBarCodeItemID = "";
            string sRelQty = "";
            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                sBarCode = sBarCode + "," + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[Fun_GetCol("条码编号")].Value);
                sBarCodeItemID = sBarCodeItemID + "," + DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[Fun_GetCol("HItemID")].Value).ToString();
            }

            if (oWeb.Set_BPrintQtyBarCode(sBarCode.Substring(1), ref sRelQty))
@@ -454,7 +538,9 @@
        {
            try
            {
                oWeb.getRunProc("exec h_p_Gy_BarCodePrintQty_Update '" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                sBarCodeItemID = sBarCodeItemID.Remove(0, 1);
                oWeb.getRunProc("update Gy_BarCodeBill_PrintQty set HPrintQty=isnull(HPrintQty,0)+1 where HBarCodeItemID in (" + sBarCodeItemID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                //oWeb.getRunProc("exec h_p_Gy_BarCodePrintQty_Update '" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
            }
            catch (Exception e)
            {

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

@@ -970,7 +970,7 @@
                if (oWeb.getRunProcByMul_Back(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //将条码存入条码打印次数记录表中
                    oWeb.getRunProc("insert into Gy_BarCodeBill_PrintQty (HBarCodeItemID,HBarCodeInterID,HBarCode,HPrintQty) select HItemID,HInterID,HBarCode,0 from Gy_BarCodeBill where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oWeb.getRunProc("insert into Gy_BarCodeBill_PrintQty (HBarCodeItemID,HBarCodeInterID,HBarCodeType,HBarCode,HPrintQty) select HItemID,HInterID,HBarCodeType,HBarCode,0 from Gy_BarCodeBill where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    MessageBox.Show("条码生成完毕！");

                    ////查询最后一行条码是否存在于条码档案表中