1.销售出库单 增加 反写源单 销售订单和发货通知单 超出 关联数量 关闭源单 2.应收单 增加 反写源单 销售出库单 和 销售订单 超出关...

zrg

2024-04-23 00d963405d2d5161052934f2cb67a2b6ea0947dd

1.销售出库单 增加 反写源单 销售订单和发货通知单   超出 关联数量  关闭源单
2.应收单 增加  反写源单 销售出库单 和 销售订单  超出关联数量  关闭源单
3.动态获取源单增加参数 Num 0蓝单   1红单  2全部
4.销售流程的测试并完善功能； 销售订单-》发货通知单-》销售出库单-》应收单 （注意： 源单类型的下拉框 需要 根据数据库 表动态加载， 关联数量 要准确 ， 审核 且 未关闭 未行关闭的行 才能下推 ，关联数量超额后，要 反写 关闭 源单 ）

 DAL/²Ö¿â¹ÜÀí/ClsKf_MoveStockBill.cs

@@ -87,6 +87,10 @@
                " where HInterID=" + lngBillKey.ToString());
                //删除关联
                DeleteRelation(ref sReturn, lngBillKey);

                //直接调拨单 ä¿®æ”¹ æ’¤é”€ å›žå¡« è°ƒæ‹¨ç”³è¯·å• å…³è”数量
                oCn.RunProc("exec h_p_Kf_UpDateRelation_MoveStockRequestToPOStockIn_Del " + omodel.HInterID.ToString());

                //删除子表
                DeleteBillSub(lngBillKey);
                //插入子表

 DAL/²Ö¿â¹ÜÀí/ClsKf_SellOutBillForLayUI.cs

@@ -51,6 +51,10 @@
                {
                    oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + lngBillKey.ToString());
                }
                else if (DetailColl[0].HSourceBillType == "1402")                    //发货通知单
                {
                    oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOutStockToPOStockIn_Add " + lngBillKey.ToString());
                }
                else
                {

@@ -80,6 +84,10 @@
                {
                    oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Add " + lngBillKey.ToString());
                }
                else if(DetailColl[0].HSourceBillType == "1402")                    //发货通知单
                {
                    oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOutStockToPOStockIn_Add " + lngBillKey.ToString());
                }
                else
                {


 DAL/ÏúÊÛ¹ÜÀí/ClsXs_ReceivableBill.cs

@@ -32,6 +32,61 @@
        #endregion
        #endregion


        #region å…³è”数量

        //删除关联
        //public override void DeleteRelation(ref string sReturn, Int64 lngBillKey)
        //{
        //    //销售订单 é”€å”®å‡ºåº“单 å…³è”数量
        //    try
        //    {
        //        if (DetailColl[0].HSourceBillType == "1401")                    //销售订单
        //        {
        //            oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + lngBillKey.ToString());
        //        }
        //        else if (DetailColl[0].HSourceBillType == "1205")                    //销售出库单
        //        {
        //            oCn.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del " + lngBillKey.ToString());
        //        }
        //        else
        //        {
        //        }
        //    }
        //    catch (Exception e)
        //    {
        //        throw (e);
        //    }
        //}
        ////新增关联
        //public override void AddNewRelation(ref string sReturn, Int64 lngBillKey)
        //{
        //    //销售订单 é”€å”®å‡ºåº“单 å…³è”数量
        //    try
        //    {
        //        if (DetailColl[0].HSourceBillType == "1401")                    //销售订单
        //        {
        //            oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Add " + lngBillKey.ToString());
        //        }
        //        else if (DetailColl[0].HSourceBillType == "1205")                    //销售出库单
        //        {
        //            oCn.RunProc("exec h_p_Xs_UpDateRelation_ICStockToPOStockIn_Add " + lngBillKey.ToString());
        //        }
        //        else
        //        {

        //        }
        //    }
        //    catch (Exception e)
        //    {
        //        throw (e);
        //    }
        //}

        #endregion



        #region ä¿®æ”¹å•æ®
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
@@ -113,6 +168,9 @@
                        ")";
                    oCn.RunProc(subSql);
                }

                ////更新订单关联数量
                //AddNewRelation(ref sReturn, omodel.HInterID);

                sReturn = "修改单据成功！";
                oCn.Commit();
@@ -229,6 +287,10 @@
                        ")";
                    oCn.RunProc(subSql);
                }

                ////更新订单关联数量
                //AddNewRelation(ref sReturn, omodel.HInterID);

                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;

 WebAPI/Controllers/Sc_MouldRepairInBillListController.cs

@@ -1632,7 +1632,7 @@

                oCN.BeginTran();

                //分布式调入单新增回填分布式调出单关联数量
                //直接调拨单 åˆ é™¤  æ’¤é”€ å›žå¡«  è°ƒæ‹¨ç”³è¯·å•  å…³è”数量
                oCN.RunProc("exec h_p_Kf_UpDateRelation_MoveStockRequestToPOStockIn_Del " + HInterID);

                oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);
@@ -1801,6 +1801,10 @@
                //销售出库删除回填销售订单关联数量
                //oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + HInterID);

                //销售出库删除回填收货通知单关联数量
                //oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOutStockToPOStockIn_Del " + HInterID);


                //oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID);
                //oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID);


 WebAPI/Controllers/WebAPIController.cs

@@ -11636,14 +11636,26 @@
        /// <returns></returns>
        [Route("Web/GetHSourceBillType")]
        [HttpGet]
        public object GetHSourceBillType(string HName)
        public object GetHSourceBillType(string HName,int Num)
        {
            try
            {
                ClsCN oCn = new ClsCN();
                DataSet oDs = new DataSet();
                //==========
                oDs = oCn.RunProcReturn("select * from  Xt_BillSourceSet where HName='"+HName+"'", "Xt_BillSourceSet");
                //有的单子源单分为红蓝单  0代表蓝单  1代表红单
                if (Num==0)
                {           //源单为蓝单
                    oDs = oCn.RunProcReturn("select * from  Xt_BillSourceSet where HName='" + HName + "' HRedBlueFlag ='"+ Num+"' ", "Xt_BillSourceSet");
                }
                else if (Num==1)
                {          //源单为红单
                    oDs = oCn.RunProcReturn("select * from  Xt_BillSourceSet where HName='" + HName + "' HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet");
                }
                else if(Num==2)
                {       //不分红蓝单
                    oDs = oCn.RunProcReturn("select * from  Xt_BillSourceSet where HName='" + HName + "'", "Xt_BillSourceSet");
                }
                
                objjson.code = "1";
                objjson.count = 1;
                objjson.Message = "获取成功！";

 WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs

@@ -1078,6 +1078,43 @@
        }
        #endregion

        #region é”€å”®å‡ºåº“单 æ ¹æ®ä¸»å†…码与子内码获取发货通知单数据
        [Route("Kf_SellOutBill/loadXs_SeOutStockBill_Push")]
        [HttpGet]
        public object loadXs_SeOrderBill_Push(long HInterID, long HSubID)
        {
            try
            {

                ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_SeOutStockBillList");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到源单信息！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region é”€å”®å‡ºåº“单 æ£€æŸ¥å•æ®æ˜¯å¦å­˜åœ¨
        /// <summary>
        /// </summary>

 WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs

@@ -363,6 +363,24 @@

                oCN.BeginTran();

                //ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_Query where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_Query");
                //foreach (DataRow row in ds.Tables[0].Rows)
                //{
                //    // èŽ·å–当前行的 HSourceBillType å€¼  
                //    string hSourceBillType = row["HSourceBillType"].ToString();

                //    if (hSourceBillType == "1401")
                //    {
                //        //应收单 åˆ é™¤å›žå¡« é”€å”®è®¢å• å…³è”数量
                //        oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + HInterID);
                //    }
                //    else if (hSourceBillType == "1205")
                //    {
                //        //应收单 åˆ é™¤å›žå¡« é”€å”®å‡ºåº“单 å…³è”数量
                //        oCN.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del     " + HInterID);
                //    }
                //}
                  
                oCN.RunProc("delete from Xs_ReceivableBillMain where HInterID = " + HInterID);
                oCN.RunProc("delete from Xs_ReceivableBillSub where HInterID= " + HInterID);


 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÑéÊÕÈë¿â/Kf_StepFoldinBillController.cs

@@ -268,6 +268,10 @@
                                 + ",HKeeperID=" + HKeeperID + ",HDeptID=" + HDeptID + "  where HInterID=" + HInterID;

                    oCN.RunProc(sql);

                    //分布式调入单 ç¼–辑 æ’¤é”€ å›žå¡«åˆ†å¸ƒå¼è°ƒå‡ºå•å…³è”数量
                    oCN.RunProc("exec h_p_Kf_UpDateRelation_ICStockToPOStockIn_Del " + HInterID);

                    //删除子表
                    oCN.RunProc("delete from Kf_ICStockBillSub where HInterID='" + HInterID + "'");
                }