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