/// <summary> /// 根据仪器ID获取仪器信息,同时输出返回仪器的安装位置信息和派发使用信息 /// </summary> /// <param name="ID"></param> /// <param name="Installation">仪器的安装位置信息</param> /// <param name="Distribution">仪器的派发使用信息</param> /// <returns></returns> public Core.DomainModel.Instrument GetInstrument(string ID, out InstrumentInstallation Installation, out InstrumentDistribution Distribution) { if (string.IsNullOrEmpty(ID)) { throw new IDNullException("仪器ID不可为空!"); } Core.DomainModel.Instrument instrument = null; Installation = null; Distribution = null; string sqlCommandText = ModuleConfiguration.SQL_CMD_SelectInstrumentById; IList <IDictionary <string, object> > dbResult = this.dmlOperable.ExeReader(sqlCommandText, new Dictionary <string, object>() { { "@ID", long.Parse(ID) } }); if (dbResult != null && dbResult.Count == 1) { instrument = new Core.DomainModel.Instrument() { ID = dbResult[0]["ID"].ToString(), //(string)dbResult[0]["ID"], Name = (string)dbResult[0]["Name"], Alias = (string)dbResult[0]["Alias"], Brand = (string)dbResult[0]["Brand"], Type = dbResult[0]["Type"] == null ? 0 :(int?)dbResult[0]["Type"], Manufacturer = (string)dbResult[0]["Manufacturer"], Model = (string)dbResult[0]["Model"], SerialNumber = (string)dbResult[0]["SerialNumber"], SKU = (string)dbResult[0]["SKU"], WarrantyPeriod = dbResult[0]["WarrantyPeriod"] == null ? 0 : (int?)dbResult[0]["WarrantyPeriod"], PurchaseDate = (DateTime?)dbResult[0]["PurchaseDate"], ShipmentDate = (DateTime?)dbResult[0]["ShipmentDate"], Remarks = (string)dbResult[0]["Remarks"] }; Installation = new InstrumentInstallation() { Instrument = instrument, AcceptanceDate = (DateTime?)dbResult[0]["AcceptanceDate"], InstallationDate = (DateTime?)dbResult[0]["InstallationDate"], Latitude = (string)dbResult[0]["Latitude"], Longitude = (string)dbResult[0]["Longitude"], Location = (string)dbResult[0]["Location"] }; Distribution = new InstrumentDistribution() { Instrument = instrument, Organization = (string)dbResult[0]["Organization"], Department = (string)dbResult[0]["Department"], WorkGroup = (string)dbResult[0]["WorkGroup"], }; } return(instrument); }
public InstrumentDistribution SetInstrumentDistribution(string InstrumentID, InstrumentDistribution Distribution) { if (string.IsNullOrEmpty(InstrumentID)) { throw new IDNullException("仪器ID不可为空!"); } string sqlCommandText = ModuleConfiguration.SQL_CMD_UpdateInstrumentDistribution; this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>() { { "@ID", long.Parse(InstrumentID) }, { "@Organization", Distribution.Organization }, { "@Department", Distribution.Department }, { "@WorkGroup", Distribution.WorkGroup }, }); return(Distribution); }