From 27d5bfd99765d6f2d4cef386a3cb999e7a2572e7 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 08 九月 2021 13:24:44 +0800
Subject: [PATCH] 关闭的日计划不再显示 按日计划和占用数量排序
---
src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs | 12 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs
index 6ef10f6..7af0539 100644
--- a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs
+++ b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs
@@ -35,9 +35,15 @@
return;
string FHMainICMOInterIDr = this.View.OpenParameter.GetCustomParameter("FHMainICMOInterIDr").ToString();//涓荤敓浜ц鍗曚富鍐呯爜
FMatrailId = this.View.OpenParameter.GetCustomParameter("FMatrailId").ToString();//鐗╂枡
- string sql = string.Format(@"/*dialect*/select a.*,b.FBILLNO FBILLNOs from JIT_MOMaterReadysBill a
- left join T_PRD_MO b on a.FHMainICMOInterIDr=b.FID
- where FCompleteCount1>0 and FHMATERID ='{0}'", FMatrailId);
+ string sql = string.Format(@"/*dialect*/
+SELECT A.*,B.FBILLNO FBILLNOS FROM JIT_MOMATERREADYSBILL A
+LEFT JOIN T_PRD_MO B ON A.FHMAINICMOINTERIDR=B.FID
+WHERE FHICMOINTERID
+NOT IN (SELECT FID FROM SC_WORKBILLSORTBILLMAIN WHERE FDOCUMENTSTATUS IN ('E'))
+AND FCOMPLETECOUNT1>0
+AND FHMATERID ='{0}'
+ORDER BY FPLANDATE ASC,FHSTOCKQTY DESC
+", FMatrailId);
DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
if (dt.Rows.Count > 0)
{
--
Gitblit v1.9.1