From 0450410946f3fb7df63f3e6bdf4e2e20e7d910f3 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 16 八月 2023 11:19:41 +0800
Subject: [PATCH] 工作任务汇报：查询结果顺序更改
---
DAL/基础资料/公用基础资料/ClsGy_Source_View.cs | 90 ++++++++++++++++++++++++++------------------
1 files changed, 53 insertions(+), 37 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 2e63ab9..9171336 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"
@@ -31,30 +31,30 @@
GC.SuppressFinalize(this);
}
//
-
- //杩斿洖椤圭洰淇℃伅
- //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;
+ 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 bool GetInfoByID_AoBang(Int64 sItemID)
{
DataSet DS;
try
@@ -160,22 +160,19 @@
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();
-
- //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.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"]);
@@ -195,6 +192,25 @@
}
}
+ //杩斿洖椤圭洰淇℃伅 濂ラ偊涓撶敤
+ public bool GetInfo_AoBang(DataSet DS)
+ {
+ try
+ {
+ omodel = new Model.ClsGy_Source_Model();
+
+ 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();
+ return true;
+
+ }
+ catch (Exception e)
+ {
+ throw (e);
+ }
+ }
+
/// <summary>
/// 寰楀埌榛樿璧勬簮鏍规嵁閮ㄩ棬
--
Gitblit v1.9.1