From 393c1fe97a7c998062a7b3b098dae95046066b90 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 28 三月 2022 17:20:02 +0800 Subject: [PATCH] nothing --- WebAPI/Sc_MouldProdInBill/Log/637838232265396309.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232322520428.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232330980775.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838232530233129.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232375909386.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232496803253.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232481862226.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232061117570.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838233170021448.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232329596870.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030502338276.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232277554698.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838232864170661.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232061107561.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231771144923.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838233058386555.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232058897406.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232390791634.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232375899394.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231863902034.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232483492371.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030418128263.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030416398124.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231863912038.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232498743385.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232278937645.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232321152707.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232330876946.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838029804058328.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838030203581153.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030502318254.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838029804118360.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232483502351.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232498713380.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232263865171.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232265416304.log | 3 + WebAPI/Vlog/webapi20220325.txt | 27 +++++++++ WebAPI/Sc_MouldProdInBill/Log/637838232322402806.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231775465243.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231775455218.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838231862021904.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232390781622.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232373949242.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838232651990045.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838029802038178.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232389145743.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838232278927644.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030418118259.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838232687379763.log | 3 + WebAPI/Sc_MouldProdOutBill/Log/637838232619747786.log | 3 + WebAPI/Sc_MouldProdInBill/Log/637838030500558119.log | 3 + 51 files changed, 177 insertions(+), 0 deletions(-) diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838029802038178.log b/WebAPI/Sc_MouldProdInBill/Log/637838029802038178.log new file mode 100644 index 0000000..15e1885 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838029802038178.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:03:00------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838029804058328.log b/WebAPI/Sc_MouldProdInBill/Log/637838029804058328.log new file mode 100644 index 0000000..fc5414c --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838029804058328.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:03:00------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838029804118360.log b/WebAPI/Sc_MouldProdInBill/Log/637838029804118360.log new file mode 100644 index 0000000..7704982 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838029804118360.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:03:00------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030416398124.log b/WebAPI/Sc_MouldProdInBill/Log/637838030416398124.log new file mode 100644 index 0000000..d3f4e2b --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030416398124.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:01------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030418118259.log b/WebAPI/Sc_MouldProdInBill/Log/637838030418118259.log new file mode 100644 index 0000000..0daa61e --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030418118259.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:01------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030418128263.log b/WebAPI/Sc_MouldProdInBill/Log/637838030418128263.log new file mode 100644 index 0000000..b62a1cc --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030418128263.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:01------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 閮ㄩ棬鍚嶇О like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030500558119.log b/WebAPI/Sc_MouldProdInBill/Log/637838030500558119.log new file mode 100644 index 0000000..e62b925 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030500558119.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:10------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030502318254.log b/WebAPI/Sc_MouldProdInBill/Log/637838030502318254.log new file mode 100644 index 0000000..f54027d --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030502318254.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:10------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838030502338276.log b/WebAPI/Sc_MouldProdInBill/Log/637838030502338276.log new file mode 100644 index 0000000..cc6ed95 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838030502338276.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:04:10------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231771144923.log b/WebAPI/Sc_MouldProdInBill/Log/637838231771144923.log new file mode 100644 index 0000000..be1bcae --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231771144923.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:37------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231775455218.log b/WebAPI/Sc_MouldProdInBill/Log/637838231775455218.log new file mode 100644 index 0000000..c5cd2aa --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231775455218.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:37------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231775465243.log b/WebAPI/Sc_MouldProdInBill/Log/637838231775465243.log new file mode 100644 index 0000000..5773a25 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231775465243.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:37------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231862021904.log b/WebAPI/Sc_MouldProdInBill/Log/637838231862021904.log new file mode 100644 index 0000000..f696a4e --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231862021904.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:46------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231863902034.log b/WebAPI/Sc_MouldProdInBill/Log/637838231863902034.log new file mode 100644 index 0000000..d6f3f7b --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231863902034.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:46------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838231863912038.log b/WebAPI/Sc_MouldProdInBill/Log/637838231863912038.log new file mode 100644 index 0000000..a1cb8f5 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838231863912038.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:39:46------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232058897406.log b/WebAPI/Sc_MouldProdInBill/Log/637838232058897406.log new file mode 100644 index 0000000..4b63ad4 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232058897406.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:05------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232061107561.log b/WebAPI/Sc_MouldProdInBill/Log/637838232061107561.log new file mode 100644 index 0000000..f57431c --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232061107561.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:06------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232061117570.log b/WebAPI/Sc_MouldProdInBill/Log/637838232061117570.log new file mode 100644 index 0000000..f8fa7d3 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232061117570.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:06------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232263865171.log b/WebAPI/Sc_MouldProdInBill/Log/637838232263865171.log new file mode 100644 index 0000000..e17f73e --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232263865171.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:26------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232265396309.log b/WebAPI/Sc_MouldProdInBill/Log/637838232265396309.log new file mode 100644 index 0000000..1f8d25a --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232265396309.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:26------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232265416304.log b/WebAPI/Sc_MouldProdInBill/Log/637838232265416304.log new file mode 100644 index 0000000..a1e594f --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232265416304.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:26------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 閮ㄩ棬 like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232277554698.log b/WebAPI/Sc_MouldProdInBill/Log/637838232277554698.log new file mode 100644 index 0000000..91a7629 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232277554698.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:27------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232278927644.log b/WebAPI/Sc_MouldProdInBill/Log/637838232278927644.log new file mode 100644 index 0000000..279bf1c --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232278927644.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:27------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232278937645.log b/WebAPI/Sc_MouldProdInBill/Log/637838232278937645.log new file mode 100644 index 0000000..d10a711 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232278937645.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:27------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232321152707.log b/WebAPI/Sc_MouldProdInBill/Log/637838232321152707.log new file mode 100644 index 0000000..b49d6f0 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232321152707.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:32------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232322402806.log b/WebAPI/Sc_MouldProdInBill/Log/637838232322402806.log new file mode 100644 index 0000000..c974eb3 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232322402806.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:32------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232322520428.log b/WebAPI/Sc_MouldProdInBill/Log/637838232322520428.log new file mode 100644 index 0000000..f93b684 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232322520428.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:32------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 搴撳瓨缁勭粐 like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232329596870.log b/WebAPI/Sc_MouldProdInBill/Log/637838232329596870.log new file mode 100644 index 0000000..b49d6f0 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232329596870.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:32------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232330876946.log b/WebAPI/Sc_MouldProdInBill/Log/637838232330876946.log new file mode 100644 index 0000000..5472252 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232330876946.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:33------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232330980775.log b/WebAPI/Sc_MouldProdInBill/Log/637838232330980775.log new file mode 100644 index 0000000..a93a460 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232330980775.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:33------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232373949242.log b/WebAPI/Sc_MouldProdInBill/Log/637838232373949242.log new file mode 100644 index 0000000..2185ae3 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232373949242.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:37------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232375899394.log b/WebAPI/Sc_MouldProdInBill/Log/637838232375899394.log new file mode 100644 index 0000000..eb4aaa1 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232375899394.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:37------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232375909386.log b/WebAPI/Sc_MouldProdInBill/Log/637838232375909386.log new file mode 100644 index 0000000..9ad8026 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232375909386.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:37------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 鐗╂枡浠g爜 like '%20204.0080%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232389145743.log b/WebAPI/Sc_MouldProdInBill/Log/637838232389145743.log new file mode 100644 index 0000000..f442f3b --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232389145743.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:38------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232390781622.log b/WebAPI/Sc_MouldProdInBill/Log/637838232390781622.log new file mode 100644 index 0000000..6adff26 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232390781622.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:39------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232390791634.log b/WebAPI/Sc_MouldProdInBill/Log/637838232390791634.log new file mode 100644 index 0000000..5fd6fb7 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232390791634.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:39------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232481862226.log b/WebAPI/Sc_MouldProdInBill/Log/637838232481862226.log new file mode 100644 index 0000000..e0f120c --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232481862226.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:48------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232483492371.log b/WebAPI/Sc_MouldProdInBill/Log/637838232483492371.log new file mode 100644 index 0000000..1d67ee7 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232483492371.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:48------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232483502351.log b/WebAPI/Sc_MouldProdInBill/Log/637838232483502351.log new file mode 100644 index 0000000..eb90c2e --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232483502351.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:48------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 妯″叿浠g爜 like '%PAK100.0420204.006900023%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232496803253.log b/WebAPI/Sc_MouldProdInBill/Log/637838232496803253.log new file mode 100644 index 0000000..15f75f1 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232496803253.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:49------------------------------ +鎴愬姛锛� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232498713380.log b/WebAPI/Sc_MouldProdInBill/Log/637838232498713380.log new file mode 100644 index 0000000..ab1fa29 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232498713380.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:49------------------------------ +鏈夋潈闄� + diff --git a/WebAPI/Sc_MouldProdInBill/Log/637838232498743385.log b/WebAPI/Sc_MouldProdInBill/Log/637838232498743385.log new file mode 100644 index 0000000..ec717c3 --- /dev/null +++ b/WebAPI/Sc_MouldProdInBill/Log/637838232498743385.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:49------------------------------ +select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25'order by hmainid desc + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838030203581153.log b/WebAPI/Sc_MouldProdOutBill/Log/637838030203581153.log new file mode 100644 index 0000000..52cc60d --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838030203581153.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 11:03:40------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='鎵嬫満浜嬩笟閮�' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838232530233129.log b/WebAPI/Sc_MouldProdOutBill/Log/637838232530233129.log new file mode 100644 index 0000000..a03cc25 --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838232530233129.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:40:53------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838232619747786.log b/WebAPI/Sc_MouldProdOutBill/Log/637838232619747786.log new file mode 100644 index 0000000..3e08cfb --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838232619747786.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:01------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838232651990045.log b/WebAPI/Sc_MouldProdOutBill/Log/637838232651990045.log new file mode 100644 index 0000000..eb1fb06 --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838232651990045.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:05------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838232687379763.log b/WebAPI/Sc_MouldProdOutBill/Log/637838232687379763.log new file mode 100644 index 0000000..3ac5b0c --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838232687379763.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:08------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838232864170661.log b/WebAPI/Sc_MouldProdOutBill/Log/637838232864170661.log new file mode 100644 index 0000000..597e3dd --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838232864170661.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:26------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838233058386555.log b/WebAPI/Sc_MouldProdOutBill/Log/637838233058386555.log new file mode 100644 index 0000000..a79d26e --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838233058386555.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:45------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Sc_MouldProdOutBill/Log/637838233170021448.log b/WebAPI/Sc_MouldProdOutBill/Log/637838233170021448.log new file mode 100644 index 0000000..927b184 --- /dev/null +++ b/WebAPI/Sc_MouldProdOutBill/Log/637838233170021448.log @@ -0,0 +1,3 @@ +------------------------2022/3/25 16:41:57------------------------------ +select * from h_v_Sc_MouldProdOutHouseBillList where 搴撳瓨缁勭粐='钃濇捣瀹炰笟闆嗗洟' + diff --git a/WebAPI/Vlog/webapi20220325.txt b/WebAPI/Vlog/webapi20220325.txt new file mode 100644 index 0000000..0436e2f --- /dev/null +++ b/WebAPI/Vlog/webapi20220325.txt @@ -0,0 +1,27 @@ +2022/3/25 11:03:00 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';鎵嬫満浜嬩笟閮� + +2022/3/25 11:04:01 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 閮ㄩ棬鍚嶇О like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';鎵嬫満浜嬩笟閮� + +2022/3/25 11:04:10 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2021-10-01' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';鎵嬫満浜嬩笟閮� + +2022/3/25 16:39:37 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';鎵嬫満浜嬩笟閮� + +2022/3/25 16:39:46 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';鎵嬫満浜嬩笟閮� + +2022/3/25 16:40:06 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:26 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 閮ㄩ棬 like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:27 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:32 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 搴撳瓨缁勭粐 like '%1%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:33 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:37 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 鐗╂枡浠g爜 like '%20204.0080%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:39 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:48 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25' and 妯″叿浠g爜 like '%PAK100.0420204.006900023%' and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 + +2022/3/25 16:40:49 and CONVERT(varchar(100),鏃ユ湡, 23) >= '2022-02-23' and CONVERT(varchar(100),鏃ユ湡, 23) <= '2022-03-25';钃濇捣瀹炰笟闆嗗洟 -- Gitblit v1.9.1