销售管理字段迁移，采购管理字段迁徙

wtt

2024-09-20 d9b200d424889c069953ec084ef9d4dd6c4ff66b

 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_ProcPriceRequestBillController.cs

@@ -619,6 +619,8 @@
            public string HBacker;
            public string HBackerDate;
            public string HBackRemark;
            public string HChangeType;
            public Double HChangeValue;
        }
        #endregion
        #region å­è¡¨
@@ -651,6 +653,7 @@
            public double HRelationMoney;
            public string HCloseMan;
            public string HEntryCloseDate;
            public int HWorkCenterID;
        }
        #endregion
        #region å®šé¢ç”³è¯·å• æ–°å¢ž/编辑
@@ -756,7 +759,8 @@
                string HBacker = mainList[0].HBacker;
                string HBackerDate = mainList[0].HBackerDate;
                string HBackRemark = mainList[0].HBackRemark;

                string HChangeType = mainList[0].HChangeType;
                Double HChangeValue = mainList[0].HChangeValue;
                //保存前控制
                DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl " + HInterID.ToString() + ",'" + HBillNo + "'," + OperationType.ToString(), "h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl");
                if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0)
@@ -785,7 +789,7 @@
                {
                    string sql = "insert into Pay_ProcPriceRequestBillMain" +
                        "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HDeptID" +
                        ",HExplanation,HRemark,HMaker,HMakeDate) " +
                        ",HExplanation,HRemark,HMaker,HMakeDate,HChangeType,HChangeValue) " +
                        "values(" +
                        "" + HYear +
                        "," + HPeriod +
@@ -801,7 +805,9 @@
                        "','" + HRemark +
                        "','" + HMaker +
                        "','" + HMakerDate +
                        "')";
                        "','" + HChangeType +
                        "'," + HChangeValue +
                        ")";

                    //主表
                    oCn.RunProc(sql);
@@ -810,6 +816,7 @@
                }
                else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0)                    //编辑
                {
                    
                    string sql = "update Pay_ProcPriceRequestBillMain set " +
                        "HYear = " + HYear +
                        ", HPeriod = " + HPeriod +
@@ -821,7 +828,9 @@
                        "', HRemark = '" + HRemark +
                        "', HUpdater = '" + HUpdater +
                        "', HUpdateDate = '" + HUpdaterDate +
                        "' where HInterID = " + HInterID;
                        "', HChangeType = '" + HChangeType +
                         "', HChangeValue = " + HChangeValue +
                        "  where HInterID = " + HInterID;

                    oCn.RunProc(sql);

@@ -912,12 +921,12 @@
                string HSourceBillType = oSub.HSourceBillType;
                double HRelationQty = oSub.HRelationQty;
                double HRelationMoney = oSub.HRelationMoney;

                int HWorkCenterID = oSub.HWorkCenterID;


                string sql = "insert into Pay_ProcPriceRequestBillSub" +
                    "(HInterID,HEntryID,HMaterID,HProcID,HSourceID,HOldPrice,HPrice,HOldFixPrice,HFixPrice,HBeginDate,HEndDate,HCostFlag,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo" +
                    ",HSourceBillType,HRelationQty,HRelationMoney) " +
                    ",HSourceBillType,HRelationQty,HRelationMoney,HWorkCenterID) " +
                    "values(" +
                    "" + HInterID +
                    "," + HEntryID +
@@ -938,6 +947,7 @@
                    "','" + HSourceBillType +
                    "'," + HRelationQty +
                    "," + HRelationMoney +
                    "," + HWorkCenterID +
                    ")";

                oCn.RunProc(sql);