From 894e4e2856d5dcf4ac8a3b7be79db7aeb9704ba7 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期三, 03 八月 2022 09:20:39 +0800
Subject: [PATCH] 工序 进站 出站 退出功能 齐套报表
---
DAL/基础资料/InterFace基础资料/ClsIF_Property_View.cs | 73 +++++++++++++++++++++++++++++++++++-
1 files changed, 71 insertions(+), 2 deletions(-)
diff --git "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs" "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs"
index 261d7c2..c713d91 100644
--- "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs"
+++ "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/InterFace\345\237\272\347\241\200\350\265\204\346\226\231/ClsIF_Property_View.cs"
@@ -2,6 +2,7 @@
using System.Collections.Generic;
using System.Text;
using System.Data;
+using DBUtility;
namespace DAL
{
@@ -17,8 +18,10 @@
public ClsIF_Property_View()
{
base.MvarReportTitle = "杈呭姪灞炴�ц缃�";
- base.MvarItemKey = "h_v_IF_Property";
- base.SQLName = "Select HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_Property where HStopflag=0 ";
+ base.MvarItemKey = "h_v_IF_PropertyByMaterID";
+ base.SQLName = "Select HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_PropertyByMaterID ";
+ base.SQLWhere = " where HStopflag=0 ";
+ base.SQLOrder = " ";
//涓嬫媺SQL
base.SQLNameForDown = " Select top 30 HItemID,HNumber 杈呭姪灞炴�т唬鐮�,HName 杈呭姪灞炴�� from h_v_IF_Property ";
base.SQLOrderForDown = " Order by HNumber ";
@@ -94,5 +97,71 @@
throw (e);
}
}
+
+ /// <summary>
+ /// 鍩虹璧勬枡甯姪-鍏ㄩ儴鍨�
+ /// </summary>
+ /// <returns></returns>
+ public override bool RefreshView(string sLike)
+ {
+ try
+ {//
+ Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
+ //
+ string sSQL = SQLName + SQLWhere + sLike + SQLOrder;
+ //缂栬緫ofrm
+ ofrm.sTitle = MvarReportTitle;
+ ofrm.sBill = MvarItemKey;
+ ofrm.txtFindInfo.Text = WherePart;
+
+ //
+ DataSet Ds;
+ Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
+ Ds = oCn.RunProcReturn(sSQL, MvarItemKey);
+ if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+ {
+ return false;
+ }
+
+ //缁戝畾
+ ofrm.grdShow.DataSource = Ds.Tables[0].DefaultView;
+ Ds.Dispose();
+ Ds = null;
+ ofrm.grdShow.SuspendLayout();
+ ofrm.grdShow.Columns[0].Visible = false;
+ ofrm.ShowDialog();
+ //寰楀埌瀵瑰簲鍒�
+ int HItemIDCol = 0;
+ int HNumberCol = 1;
+ int HNameCol = 2;
+ //
+ if (ofrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
+ {
+ if (ofrm.grdShow.CurrentRow == null)
+ {
+ return false;
+ }
+ oModel = new ClsGy_Base_Model();
+ oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
+ oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
+ oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
+ }
+ else
+ {
+ return false;
+ }
+ //
+ ofrm.Dispose();
+ ofrm = null;
+ //
+ return true;
+ }
+ catch (Exception e)
+ {
+ throw (e);
+ }
+ }
+
+
}
}
--
Gitblit v1.9.1