From 2731daa8707f14c8ade1370790c8884179984232 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期五, 23 八月 2024 16:08:45 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/基础资料/基础资料/Gy_UnitConvertRateController.cs | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_UnitConvertRateController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_UnitConvertRateController.cs"
index 3453dcc..222eabd 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_UnitConvertRateController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_UnitConvertRateController.cs"
@@ -181,7 +181,8 @@
FormId = "BD_UNITCONVERTRATE",
FieldKeys = "FUNITCONVERTRATEID,FBILLNO,FMATERIALID,FUSEORGID,FCREATEORGID,FFORBIDSTATUS" +
",FCURRENTUNITID,FDESTUNITID,FCONVERTTYPE,FCONVERTNUMERATOR,FCONVERTDENOMINATOR" +
- ",FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE",
+ ",FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE" +
+ ",FMATERIALID.FNUMBER",
FilterString = "",
OrderString = "",
TopRowCount = 0,
@@ -245,6 +246,7 @@
HModifyTime = DBUtility.ClsPub.isDate(arr[i, 14]),
HStopEmp = DBUtility.ClsPub.isStrNull(arr[i, 17]),
HStopTime = DBUtility.ClsPub.isDate(arr[i, 18]),
+ HMaterNumber = DBUtility.ClsPub.isStrNull(arr[i, 19]),
};
//鍐欏叆鍗曚綅鎹㈢畻琛ㄦ暟鎹�
@@ -253,7 +255,7 @@
(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID
,HBILLNO,HMATERID,HCURRENTUNITID,HDESTUNITID,HCONVERTTYPE,HCONVERTNUMERATOR
- ,HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID
+ ,HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID,HMaterNumber
,HMakeEmp,HMakeTime
,HCheckEmp,HCheckTime
,HModifyEmp,HModifyTime
@@ -261,7 +263,7 @@
Values({subData.HItemID},'{subData.HNumber}','{subData.HName}','{subData.HShortNumber}',{subData.HParentID},{subData.HLevel}
,{subData.HEndFlag},{subData.HStopflag},'{subData.HRemark}','{subData.HUseFlag}',{subData.HUSEORGID},{subData.HCREATEORGID}
,'{subData.HBILLNO}',{subData.HMATERID},{subData.HCURRENTUNITID},{subData.HDESTUNITID},{subData.HCONVERTTYPE},{subData.HCONVERTNUMERATOR}
- ,{subData.HCONVERTDENOMINATOR},'{subData.HFORBIDSTATUS}',{subData.HUnitID}
+ ,{subData.HCONVERTDENOMINATOR},'{subData.HFORBIDSTATUS}',{subData.HUnitID},'{subData.HMaterNumber}'
,'{subData.HMakeEmp}',case when '{subData.HMakeTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HMakeTime}' end
,'{subData.HCheckEmp}',case when '{subData.HCheckTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HCheckTime}' end
,'{subData.HModifyEmp}',case when '{subData.HModifyTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HModifyTime}' end
--
Gitblit v1.9.1