From d3835d49a3c673a37c78a79600320e287d4d320b Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期六, 06 三月 2021 10:54:38 +0800 Subject: [PATCH] 日计划导入增加删除用料清单审核状态验证 齐套信息明细 颜色渲染更改 --- src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git a/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs b/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs index 781dd1b..bb3f2a8 100644 --- a/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs +++ b/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs @@ -277,6 +277,23 @@ this.View.ShowErrMessage(_result); return; } + //鏍¢獙鐢熶骇鐢ㄦ枡娓呭崟鏄惁瀹℃牳 + foreach (DynamicObject current in entityDataObjoct) + { + //鏍规嵁鐢熶骇璁㈠崟鍙峰拰鐗╂枡鏌ヨ鏄惁瀛樺湪鏄庣粏 +鐢熶骇璁㈠崟鏄庣粏琛屽彿 + sql = string.Format(@"/*dialect*/SELECT FBILLNO FROM T_PRD_PPBOM T1 +WHERE T1.FMOBILLNO = '{0}' AND T1.FMATERIALID = '{1}' AND T1.FMOENTRYSEQ = '{2}' and FDOCUMENTSTATUS <>'C' +", Convert.ToString(current["FSCOrderNo"]), Convert.ToString(current["FMatrailId_Id"]), Convert.ToString(current["FSRCBILLENTRYSEQ"])); + DataTable dt = new DataTable(); + dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0]; + if (dt.Rows.Count > 0) + _result += "搴忓彿锛�" + Convert.ToString(current["SEQ"]) + ",鐢熶骇璁㈠崟鍙凤細" + Convert.ToString(current["FSCOrderNo"]) + ",鐢熶骇璁㈠崟鏄庣粏琛屽彿锛�" + Convert.ToString(current["FSRCBILLENTRYSEQ"]) + "鐗╂枡" + (current["FMatrailId"] as DynamicObject)["Number"] + "瀵瑰簲鐨勭敓浜х敤鏂欐竻鍗曪細" + dt.Rows[0][0] + "鏈鏍�"; + } + if (_result != "") + { + this.View.ShowErrMessage(_result); + return; + } foreach (DynamicObject current in entityDataObjoct) { if (Convert.ToInt32(current["FNoScheduled"]) < 0) -- Gitblit v1.9.1