public override int GetHashCode() { return(CLASSCODE.GetHashCode() ^ STAFFCODE.GetHashCode()); }
public IEnumerable<view_INSTRUMENT> GetInstrument(CLASSCODE c) { try { List<Core.Business.view_INSTRUMENT> iNSTRUMENTlist = new List<Core.Business.view_INSTRUMENT>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@rootpath", SqlDbType.NVarChar, c.RootPath); SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetInstrument); if (reader != null) { while (reader.Read()) { Core.Business.view_INSTRUMENT iNSTRUMENT = new Core.Business.view_INSTRUMENT(); if (!reader.IsDBNull(0)) iNSTRUMENT.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) iNSTRUMENT.InstruCode = reader.GetString(1); if (!reader.IsDBNull(2)) iNSTRUMENT.LaboratoryId = reader.GetGuid(2); if (!reader.IsDBNull(3)) iNSTRUMENT.WorkingforUnitId = reader.GetGuid(3); if (!reader.IsDBNull(4)) iNSTRUMENT.MachineGroupId = reader.GetGuid(4); if (!reader.IsDBNull(5)) iNSTRUMENT.PERSONNELID = reader.GetGuid(5); if (!reader.IsDBNull(6)) iNSTRUMENT.HNAME = reader.GetString(6); if (!reader.IsDBNull(7)) iNSTRUMENT.ENAME = reader.GetString(7); if (!reader.IsDBNull(8)) iNSTRUMENT.ALIAS = reader.GetString(8); if (!reader.IsDBNull(9)) iNSTRUMENT.CLASSCODE = reader.GetString(9); if (!reader.IsDBNull(10)) iNSTRUMENT.SITE = reader.GetGuid(10); if (!reader.IsDBNull(11)) iNSTRUMENT.CITY = reader.GetGuid(11); if (!reader.IsDBNull(12)) iNSTRUMENT.SPECTYPE = reader.GetString(12); if (!reader.IsDBNull(13)) iNSTRUMENT.GETMODE = reader.GetGuid(13); if (!reader.IsDBNull(14)) iNSTRUMENT.WorkState = reader.GetInt32(14); if (!reader.IsDBNull(15)) iNSTRUMENT.UseState = reader.GetInt32(15); if (!reader.IsDBNull(16)) iNSTRUMENT.MANUFACTURE = reader.GetString(16); if (!reader.IsDBNull(17)) iNSTRUMENT.COUNTRYCODE = reader.GetGuid(17); if (!reader.IsDBNull(18)) iNSTRUMENT.PRODUCINGAREA = reader.GetString(18); if (!reader.IsDBNull(19)) iNSTRUMENT.PRODUCESORT = reader.GetGuid(19); if (!reader.IsDBNull(20)) iNSTRUMENT.VALUERMB = reader.GetDecimal(20); if (!reader.IsDBNull(21)) iNSTRUMENT.NATIONALPAY = reader.GetDecimal(21); if (!reader.IsDBNull(22)) iNSTRUMENT.BUGETSOURCE = reader.GetGuid(22); if (!reader.IsDBNull(23)) iNSTRUMENT.PRODUCEDATE = reader.GetDateTime(23); if (!reader.IsDBNull(24)) iNSTRUMENT.PURCHASEDATE = reader.GetDateTime(24); if (!reader.IsDBNull(25)) iNSTRUMENT.DISCARDTIME = reader.GetDateTime(25); if (!reader.IsDBNull(26)) iNSTRUMENT.GUIDELINE = reader.GetString(26); if (!reader.IsDBNull(27)) iNSTRUMENT.FUNCTIONFEATURES = reader.GetString(27); if (!reader.IsDBNull(28)) iNSTRUMENT.EXAMINATION = reader.GetGuid(28); if (!reader.IsDBNull(29)) iNSTRUMENT.HasCMA = reader.GetInt32(29); if (!reader.IsDBNull(30)) iNSTRUMENT.IsSpecial = reader.GetInt32(30); if (!reader.IsDBNull(31)) iNSTRUMENT.TOTALLY = reader.GetInt32(31); if (!reader.IsDBNull(32)) iNSTRUMENT.ACCEPTMISSION = reader.GetInt32(32); if (!reader.IsDBNull(33)) iNSTRUMENT.EXTERNALSERVICE = reader.GetInt32(33); if (!reader.IsDBNull(34)) iNSTRUMENT.PICTURE = reader.GetInt32(34); if (!reader.IsDBNull(35)) iNSTRUMENT.ATTACHMENT = reader.GetInt32(35); if (!reader.IsDBNull(36)) iNSTRUMENT.MEDIA = reader.GetInt32(36); if (!reader.IsDBNull(37)) iNSTRUMENT.PURPOSEID = reader.GetString(37); if (!reader.IsDBNull(38)) iNSTRUMENT.REALMID = reader.GetString(38); if (!reader.IsDBNull(39)) iNSTRUMENT.WRITEDATE = reader.GetDateTime(39); if (!reader.IsDBNull(40)) iNSTRUMENT.UPDATEDATE = reader.GetDateTime(40); if (!reader.IsDBNull(41)) iNSTRUMENT.REMARK = reader.GetString(41); if (!reader.IsDBNull(42)) iNSTRUMENT.AUDITINGSTATE = reader.GetInt32(42); if (!reader.IsDBNull(43)) iNSTRUMENT.ASSESSOR = reader.GetString(43); if (!reader.IsDBNull(44)) iNSTRUMENT.AUDITINGDATE = reader.GetDateTime(44); if (!reader.IsDBNull(45)) iNSTRUMENT.RollCall = reader.GetInt64(45); if (!reader.IsDBNull(46)) iNSTRUMENT.OringalId = reader.GetInt32(46); if (!reader.IsDBNull(47)) iNSTRUMENT.Gather = reader.GetInt32(47); if (!reader.IsDBNull(48)) iNSTRUMENT.RootPath = reader.GetString(48); iNSTRUMENT.MarkOld(); iNSTRUMENTlist.Add(iNSTRUMENT); } reader.Close(); } return iNSTRUMENTlist; } catch (Exception ex) { throw ex; } }
public QuestionRecord(string sName, TYPECODE iType, CLASSCODE iClass) { mQClass = (UInt16)iClass; mQType = (UInt16)iType; mQName = sName; }