From 9d99644033cf0d1d2d331aa1a3656bddcd20aaf3 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 10 十月 2023 10:52:21 +0800
Subject: [PATCH] 乔一优化
---
WebAPI/Controllers/仓存管理/领料发货/Kf_MateOutBillController.cs | 2 +-
WebAPI/WebAPI.csproj | 1 +
2 files changed, 2 insertions(+), 1 deletions(-)
diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs"
index 427cbd4..7262243 100644
--- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs"
+++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\351\242\206\346\226\231\345\217\221\350\264\247/Kf_MateOutBillController.cs"
@@ -413,7 +413,7 @@
//string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 ";
string sql1 = string.Format(@"select HMaterID ,鐗╂枡浠ｇ爜 HMaterCode ,鐗╂枡鍚嶇О HMaterName,鐗╂枡鍏紡 HMaterRuleType,瑙勬牸鍨嬪彿 HMaterSpec,鐢ㄩ噺 HRate, HUnitID,璁￠噺鍗曚綅浠ｇ爜 HUnitCode,璁￠噺鍗曚綅 HUnitName,搴旀敹鏁伴噺 HQtyMust,瀹炴敹鏁伴噺 HQty,鍗曚环 HPrice,閲戦 HMoney,HWHID,棰嗘枡浠撳簱浠ｇ爜 HWHCode,棰嗘枡浠撳簱 HWHName,琛ㄤ綋澶囨敞 HRemark
from h_v_IF_MateOutBillList WHERE 1=1");
- string sql = sql1 + sqlWhere;
+ string sql = sql1 + sqlWhere + " order by HSubID asc";
ds = oCN.RunProcReturn(sql, "H_V_IF_MATEOUTBILLLIST");
}
//鏌ユ眹鎬�
diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj
index 873af06..7758769 100644
--- a/WebAPI/WebAPI.csproj
+++ b/WebAPI/WebAPI.csproj
@@ -592,6 +592,7 @@
<Compile Include="Controllers\鐢熶骇绠＄悊\璐ㄩ噺姹囨姤鍗昞Sc_QualityReportBillController.cs" />
<Compile Include="Controllers\椤圭洰绠＄悊\涓氱哗鎸囨爣\PM_YearEmployeeMoneyBillController.cs" />
<Compile Include="Controllers\椤圭洰绠＄悊\宸ヤ綔浠诲姟\PM_WorkTaskBillController.cs" />
+ <Compile Include="Controllers\椤圭洰绠＄悊\宸ヤ綔鍛ㄨ鍒抃PM_WorkTaskWeekBillController.cs" />
<Compile Include="Controllers\椤圭洰绠＄悊\宸ョ▼椤圭洰\PM_ProjectBillController.cs" />
<Compile Include="Controllers\椤圭洰绠＄悊\鎶ヨ〃鍒嗘瀽\PM_ReportController.cs" />
<Compile Include="Controllers\椤圭洰绠＄悊\椤圭洰闃舵\Gy_ProjectStageController.cs" />
--
Gitblit v1.9.1