/// <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 InstrumentInstallation SetInstrumentInstallation(string InstrumentID, InstrumentInstallation Installation)
{
if (string.IsNullOrEmpty(InstrumentID))
{
throw new IDNullException("仪器ID不可为空！");
}
string sqlCommandText = ModuleConfiguration.SQL_CMD_UpdateInstrumentInstallation;
this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>()
{
{ "@ID", long.Parse(InstrumentID) },
{ "@Latitude", Installation.Latitude },
{ "@Longitude", Installation.Longitude },
{ "@Location", Installation.Location },
{ "@InstallationDate", Installation.InstallationDate },
{ "@AcceptanceDate", Installation.AcceptanceDate }
});
return(Installation);
}
