2

lan

2024-05-23 bb504ec80910d12bed70178d4de6e03769e0472d

 WebAPI/Controllers/CGGL/Cg_PayableBillController.cs

@@ -151,6 +151,7 @@
                            return objJsonResult;
                        }
                    }

                    UserName = oItem.HMaker;  //制单人
                    oItem.HBillType = "1114";
                    oItem.HBillSubType = "1114";
@@ -173,10 +174,10 @@
                msg3 = msg3.Replace("\\", "");
                msg3 = msg3.Replace("\n", "");  //\n
                //msg2 = msg2.Replace("'", "’");
                List<Model.ClsCg_PayableBillSub> ls = new List<Model.ClsCg_PayableBillSub>();
                ls = oListModels.getObjectByJson_Cg_PayableBillSub(msg3);
                List<Model.ClsCg_PayableSub> ls = new List<Model.ClsCg_PayableSub>();
                ls = oListModels.getObjectByJson_Cg_PayableSub(msg3);
                int i = 0;
                foreach (Model.ClsCg_PayableBillSub oItemSub in ls)
                foreach (Model.ClsCg_PayableSub oItemSub in ls)
                {
                    i++;
                    oItemSub.HEntryID = i;
@@ -189,11 +190,22 @@

                }

                //进行 会计期间 结账 的判断和控制
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }

                //保存
                //保存完毕后处理
                bool bResult;
                if (refSav == "Add")
                {
                 
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                }
@@ -331,12 +343,27 @@
                //}
                ////==================================================================================  

                //进行 会计期间 结账 的判断和控制
                int sYear = 0;
                int sPeriod = 0;
                DateTime HDate = DateTime.Now;
                if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                {
                    objJsonResult.Message = s;
                    return objJsonResult;
                }


                oCN.BeginTran();

                //应付单 删除 撤销 采购入库单 关联数量
                oCN.RunProc("exec h_p_Cg_UpDateRelation_POStockInToPayable_Del " + HInterID);

                //应付单 删除 撤销 采购订单 关联数量
                oCN.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPayable_Del " + HInterID);

                oCN.RunProc("delete from Cg_PayableBillMain where HInterID = " + HInterID);
                oCN.RunProc("delete from Cg_PayableBillSub where HInterID= " + HInterID);
                oCN.RunProc("delete from Cg_PayableSub where HInterID= " + HInterID);

                ////删除后控制==================================================================================      
                //string sql2 = "exec h_p_Xs_ReceivableBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
@@ -367,7 +394,7 @@

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "您已删除单据号为" + BillOld.omodel.HBillNo + "的应收单！";
                objJsonResult.Message = "您已删除单据号为" + BillOld.omodel.HBillNo + "的应付单！";
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -382,6 +409,8 @@
            }
        }
        #endregion



        #region 应付单 审核/反审核
        /// <summary>
@@ -477,6 +506,17 @@
                //进行需要进行的审核/反审核操作
                if (IsAudit == 0) //审核提交
                {
                    //进行 会计期间 结账 的判断和控制
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    DateTime HDate = DateTime.Now;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.Message = s;
                        return objJsonResult;
                    }

                    oCN.BeginTran();

                    //记录返回信息
@@ -531,6 +571,17 @@
                }
                if (IsAudit == 1) //反审核提交
                {
                    //进行 会计期间 结账 的判断和控制
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    DateTime HDate = DateTime.Now;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.Message = s;
                        return objJsonResult;
                    }

                    ////反审核前控制=========================================        
                    //string sql1 = "exec h_p_Xs_ReceivableBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";
                    //ds = oCN.RunProcReturn(sql1, "h_p_Xs_ReceivableBill_BeforeUnCheckCtrl");
@@ -576,7 +627,7 @@
            }
            catch (Exception e)
            {
                oCN.RollBack();
                //oCN.RollBack();

                objJsonResult.code = "0";
                objJsonResult.count = 0;
@@ -587,6 +638,7 @@
        }
        #endregion


        #region 应付单 关闭/反关闭
        /// <summary>
        /// </summary>