From e3d40db116e17fa1401ebb3bb04ea246f74db79b Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期一, 18 四月 2022 14:26:33 +0800
Subject: [PATCH] 车间仓库对照列表 提料计划信息表列表 要料计划信息表列表
---
DAL/基础资料/公用基础资料/ClsGy_Source_View.cs | 94 ++++++++++++++++++++++++++++++++++++++--------
1 files changed, 77 insertions(+), 17 deletions(-)
diff --git "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs" "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
index 46a6ac1..2e63ab9 100644
--- "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
+++ "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
@@ -33,17 +33,73 @@
//
//杩斿洖椤圭洰淇℃伅
+ //public override bool GetInfoByID(Int64 sItemID)
+ //{
+ // DataSet DS ;
+ // try
+ // {
+ // DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
+ // if (DS.Tables[0].Rows.Count == 0)
+ // return false;
+ // else
+ // {
+ // return GetInfo(DS);
+ // }
+ // }
+ // catch (Exception e)
+ // {
+ // throw (e);
+ // }
+ //}
+
+
+ //杩斿洖椤圭洰淇℃伅
public override bool GetInfoByID(Int64 sItemID)
{
- DataSet DS ;
+ DataSet DS;
try
{
- DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
- if (DS.Tables[0].Rows.Count == 0)
+ Pub_Control.frmHlpInfo_View ofrm = new Pub_Control.frmHlpInfo_View();
+ ofrm.sTitle = MvarReportTitle;
+ ofrm.sBill = MvarItemKey;
+ ofrm.txtFindInfo.Text = WherePart;
+ DS = oCn.RunProcReturn("select distinct HItemID,b.HNumber ,b.HName from Sc_ICMOBillStatus_Tmp a inner join Gy_Source b on a.HSourceID = b.HItemID Where a.HEMPID =" + sItemID + " or a.HEMPID2 = " + sItemID + " or HEMPID3 = " + sItemID + "", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
+ if (DS.Tables[0].Rows.Count == 0)
return false;
else
{
- return GetInfo(DS);
+ //缁戝畾
+ 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 DBUtility.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)
@@ -104,19 +160,23 @@
omodel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
omodel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim();
omodel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim();
- omodel.HHelpCode = DS.Tables[0].Rows[0]["HHelpCode"].ToString().Trim();
- omodel.HShortNumber = DS.Tables[0].Rows[0]["HShortNumber"].ToString().Trim();
- omodel.HParentID = Convert.ToInt64(DS.Tables[0].Rows[0]["HParentID"]);
- omodel.HLevel = Convert.ToInt64(DS.Tables[0].Rows[0]["HLevel"]);
- omodel.HEndFlag = (bool)DS.Tables[0].Rows[0]["HEndFlag"];
- omodel.HStopflag = (bool)DS.Tables[0].Rows[0]["HStopflag"];
- omodel.HRemark = DS.Tables[0].Rows[0]["HRemark"].ToString().Trim();
- omodel.HProcID = Convert.ToInt64(DS.Tables[0].Rows[0]["HProcID"]);
- omodel.HRelationID = Convert.ToInt64(DS.Tables[0].Rows[0]["HRelationID"]);
- omodel.HCenterID = Convert.ToInt64(DS.Tables[0].Rows[0]["HCenterID"]);
- omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCodeForBase"].ToString().Trim();
- omodel.HType = DS.Tables[0].Rows[0]["HType"].ToString().Trim();
- omodel.HEquipFileID_K3 = Convert.ToInt64(DS.Tables[0].Rows[0]["HEquipFileID_K3"]);
+
+ //20220331淇敼
+ //omodel.HHelpCode = DS.Tables[0].Rows[0]["HHelpCode"].ToString().Trim();
+ //omodel.HShortNumber = DS.Tables[0].Rows[0]["HShortNumber"].ToString().Trim();
+ //omodel.HParentID = Convert.ToInt64(DS.Tables[0].Rows[0]["HParentID"]);
+ //omodel.HLevel = Convert.ToInt64(DS.Tables[0].Rows[0]["HLevel"]);
+ //omodel.HEndFlag = (bool)DS.Tables[0].Rows[0]["HEndFlag"];
+ //omodel.HStopflag = (bool)DS.Tables[0].Rows[0]["HStopflag"];
+ //omodel.HRemark = DS.Tables[0].Rows[0]["HRemark"].ToString().Trim();
+ //omodel.HProcID = Convert.ToInt64(DS.Tables[0].Rows[0]["HProcID"]);
+ //omodel.HRelationID = Convert.ToInt64(DS.Tables[0].Rows[0]["HRelationID"]);
+ //omodel.HCenterID = Convert.ToInt64(DS.Tables[0].Rows[0]["HCenterID"]);
+ //omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCodeForBase"].ToString().Trim();
+ //omodel.HType = DS.Tables[0].Rows[0]["HType"].ToString().Trim();
+ //omodel.HEquipFileID_K3 = Convert.ToInt64(DS.Tables[0].Rows[0]["HEquipFileID_K3"]);
+ //淇敼鐨勫湴鏂瑰埌杩欓噷
+
//omodel.HGroupK3ID = Convert.ToInt64(DS.Tables[0].Rows[0]["HGroupK3ID"]);
//omodel.HGroupID = Convert.ToInt64(DS.Tables[0].Rows[0]["HGroupID"]);
//omodel.HDeptID = Convert.ToInt64(DS.Tables[0].Rows[0]["HDeptID"]);
--
Gitblit v1.9.1