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;
}
