/// <summary>
/// 通过药品注册码获取药品信息
/// </summary>
/// <returns>药品检测信息</returns>
public DrugInfo GetDrugInfoFromLicense(string licenseCode)
{
try
{
List <DrugInfo> drugs = new List <DrugInfo>();
string sqlstr = "select * from " + DBTableName[(int)TDBableType.DRUG] + " where passBatch='" + licenseCode + "'";
OleDbCommand myAccessCommand = new OleDbCommand(sqlstr, myAccessConn);
OleDbDataReader myDataReader = myAccessCommand.ExecuteReader();
DrugInfo retDrugInfo = null;
if (myDataReader.Read())
{
retDrugInfo = new DrugInfo();
retDrugInfo.chemicalName = GetData <string>(myDataReader, "phyName");
retDrugInfo.commercialName = GetData <string>(myDataReader, "tradeCName");
retDrugInfo.productUnit = GetData <string>(myDataReader, "nowProUnit");
retDrugInfo.form = GetData <string>(myDataReader, "doseType");
retDrugInfo.specification = GetData <string>(myDataReader, "Specs");
retDrugInfo.licenseCode = GetData <string>(myDataReader, "passBatch");
}
myDataReader.Close();
return(retDrugInfo);
}
catch (Exception ex)
{
ErrorString = ex.Message;
return(null);
}
}
public ModelInfo(DrugInfo drug)
{
thresold = 0.97;
licenseCode = drug.licenseCode;
productUnit = drug.productUnit;
form = drug.form;
specification = drug.specification;
chemicalName = drug.chemicalName;
thisObject = this;
files = new ObservableCollection <Ai.Hong.CommonLibrary.spectrumDisplayInfo>();
regions = new ObservableCollection <region>();
}
public bool UpdateDrugInfo(DrugInfo drugInfo)
{
string sqlstr = "update " + DBTableName[(int)TDBableType.DRUG] + " set ";
sqlstr += " phyName='" + drugInfo.chemicalName + "',";
sqlstr += " nowProUnit='" + drugInfo.productUnit + "',";
sqlstr += " doseType='" + drugInfo.form + "',";
sqlstr += " Specs='" + drugInfo.specification;
sqlstr += " passBatch='" + drugInfo.licenseCode + "'";
if (ExcuteSqlCommand(sqlstr) == false)
{
return(false);
}
return(true);
}
/// <summary>
/// 新增药品检测信息
/// </summary>
/// <param name="drugInfo">药品检测信息</param>
/// <returns>操作结果</returns>
public bool InsertDrugInfo(DrugInfo drugInfo)
{
string sqlstr = "insert into " + DBTableName[(int)TDBableType.DRUG];
sqlstr += "(phyName, nowProUnit, doseType, Specs, packSpecs, passBatch) values(";
sqlstr += "'" + drugInfo.chemicalName + "',";
sqlstr += "'" + drugInfo.productUnit + "',";
sqlstr += "'" + drugInfo.form + "',";
sqlstr += "'" + drugInfo.specification + "',";
sqlstr += "'" + drugInfo.licenseCode + "')";
if (ExcuteSqlCommand(sqlstr) == false)
{
return(false);
}
return(true);
}
