设备履历+器具履历

zzr99

2022-08-16 2cea3c0d7cb988f28b9c296457cd89a34ea1d0e8

 DAL/基础资料/公用基础资料/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>
        /// 寰楀埌榛樿璧勬簮鏍规嵁閮ㄩ棬