增加一个按钮，批量获取凭证号

@大海@

于 2024-08-01 17:18:28 发布

阅读量131

点赞数 1

分类专栏：金蝶云星空文章标签：金蝶云星空

本文链接：https://blog.csdn.net/zhanzhib/article/details/140852033

版权

金蝶云星空专栏收录该内容

16 篇文章 0 订阅

订阅专栏

create  PROCEDURE Cux_Ar_ServiceLedger_Voucher_Proc
 @OrgId Int ,
 @result Int output 
AS
BEGIN 
 SET NOCOUNT ON
 DECLARE @Date DATETIME 
 IF @OrgId = 0 or @OrgId=''
 BEGIN  
   RAISERROR(N'获取当前组织ID失败！', 16, 1)  
   RETURN
 END 
 SET @Date = GETDATE()
 BEGIN TRANSACTION 
 BEGIN Try 
   update lsar set lsar.fVOUCHERNO=gv.FVOUCHERGROUPNO ,lsar.FVOUCHERPERIOD=(gv.FYEAR*100+gv.FPERIOD )   from   T_BAS_VOUCHER svh  inner join T_AR_RECEIVABLE ar     on ar.FID = svh.FSourceBillID      and svh.FSourceBillKey = 'AR_receivable'   inner join T_GL_VOUCHER gv   on  gv.FVOUCHERID = svh.FGLVoucherID   inner join  t_Ar_ReceivableEntry arl   on ar.FID=arl.FID  
   inner join t_Ar_ReceivableEntry_LK arlk 
   on arlk.FENTRYID=arl.FENTRYID  
   and arlk.FSTableName='LIX_t_ServiceLegderAr'  inner join
    LIX_t_ServiceLegderAr lsar  on lsar.FDetailID= arlk.FSId  where  lsar.fVOUCHERNO=0  and ar.FSETTLEORGID=@OrgId; 
    set  @result=@@ROWCOUNT 
    COMMIT TRANSACTION
  END Try
  BEGIN Catch 
    ROLLBACK TRANSACTION  
    DECLARE @ErrorMessage NVARCHAR(2000) 
    DECLARE @ErrorSeverity INT 
    DECLARE @ErrorState INT 
    SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE() 
    RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) 
  END Catch 
 END

using cux.kd.k3coloud.ar.serviceLedger;
using Kingdee.BOS.App.Data;
using Kingdee.BOS;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.Core.List.PlugIn;
using Kingdee.BOS.Util;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using Kingdee.BOS.Core.DynamicForm;

namespace cux.kd.k3coloud.ar.serviceLedger
{
    [Description("获取凭证号插件")]
    [HotUpdate]
    public class CuxArServiceLedgerListPlugin : AbstractListPlugIn
    {
        private static readonly  Object Lockflag =new object();
        public override void AfterBarItemClick(AfterBarItemClickEventArgs e)
        {
            base.AfterBarItemClick(e);
            if (e.BarItemKey.Equals("PBQO_Voucher_Button", StringComparison.OrdinalIgnoreCase))
            {
                this.View.ShowMessage("确定批量获取凭证号！", MessageBoxOptions.YesNo, action: (result) =>
                {
                    if (result == MessageBoxResult.Yes)
                    {
                        lock (Lockflag)
                        {
                            this.View.GetBarItem("", "PBQO_Voucher_Button").Enabled = false;
                            this.View.UpdateView("PBQO_Voucher_Button");
                            List<SqlParam> paramList = new List<SqlParam>();
                            paramList.Add(new SqlParam("@OrgId", KDDbType.Int32, this.Context.CurrentOrganizationInfo.ID));
                            paramList.Add(new SqlParam("@result", KDDbType.Int64, '0') { Direction = ParameterDirection.Output });
                            List<SqlParam> sp = DBUtils.ExecuteStoreProcedure(this.Context, "Cux_Ar_ServiceLedger_Voucher_Proc", paramList);
                            String rs = sp[0].Value.ToString();
                            this.View.ShowMessage(String.Format("更新记录数量为：{0}", rs), MessageBoxType.Notice);
                            this.View.GetBarItem("", "PBQO_Voucher_Button").Enabled = true;
                            this.View.UpdateView("PBQO_Voucher_Button");
                        }
                    }
                }
                );
                }
        }


    }
}