public Core.DomainModel.Instrument SetInstrument(string ID, Core.DomainModel.Instrument Instrument) { if (Instrument == null || string.IsNullOrEmpty(ID)) { throw new IDNullException("仪器ID不可为空!"); } string sqlCommandText = ModuleConfiguration.SQL_CMD_UpdateInstrument; this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>() { { "@ID", long.Parse(ID) }, { "@Name", Instrument.Name }, { "@Alias", Instrument.Alias }, { "@Type", Instrument.Type }, { "@Model", Instrument.Model }, { "@SerialNumber", Instrument.SerialNumber }, { "@Manufacturer", Instrument.Manufacturer }, { "@Brand", Instrument.Brand }, { "@SKU", Instrument.SKU }, { "@WarrantyPeriod", Instrument.WarrantyPeriod }, { "@ShipmentDate", Instrument.ShipmentDate }, { "@PurchaseDate", Instrument.PurchaseDate }, { "@Remarks", Instrument.Remarks } }); return(Instrument); }
/// <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); }
/// <summary> /// 根据仪器ID获取仪器 /// </summary> /// <param name="ID"></param> /// <returns></returns> public Core.DomainModel.Instrument GetInstrument(string ID) { if (string.IsNullOrEmpty(ID)) { throw new IDNullException("仪器ID不可为空!"); } Core.DomainModel.Instrument instrument = null; string sqlCommandText = ModuleConfiguration.SQL_CMD_SelectInstrumentBasicById; 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(), 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 ? -1 : (int?)dbResult[0]["WarrantyPeriod"], PurchaseDate = (DateTime?)dbResult[0]["PurchaseDate"], ShipmentDate = (DateTime?)dbResult[0]["ShipmentDate"], Remarks = (string)dbResult[0]["Remarks"] }; } return(instrument); }