/// <summary>
/// 初始化科室对应病区数据
/// </summary>
/// <param name="sqlExecutor"></param>
public void InitializeCorrespondingWards(IDataAccess sqlExecutor)
{
if ((_correspondingWards == null) || (_correspondingWards.Count == 0))
{
_correspondingWards = new Collection <string>();
// 查找对应病区
DataRow[] rows = sqlExecutor.GetRecords(
PersistentObjectFactory.GetQuerySentenceByName("SelectDepartmentWardMappings")
, String.Format(CultureInfo.CurrentCulture, "DeptID = '{0}'", Code)
, true);
foreach (DataRow row in rows)
{
_correspondingWards.Add(row["WardID"].ToString());
}
}
}
/// <summary>
/// 取药品默认的用法、频次、数量及单位
/// </summary>
/// <param name="systemFlag">系统标志(区分门诊还是住院)</param>
/// <param name="sqlExecutor"></param>
/// <returns></returns>
public DruggeryOrderContent GetDefaultUsageFrequency(SystemApplyRange systemFlag, IDataAccess sqlExecutor)
{
if (sqlExecutor == null)
{
throw new ArgumentNullException(MessageStringManager.GetString("ParameterIsNull", "SQLHelper"));
}
DataRow dr = sqlExecutor.GetRecord(PersistentObjectFactory.GetQuerySentenceByName("SelectDefUsageOfDruggery")
, String.Format(CultureInfo.CurrentCulture, " PlaceID = {0} and Mark in (1400, {1:D})", ProductSerialNo, systemFlag)
, true);
DruggeryOrderContent result = new DruggeryOrderContent();
if (dr != null)
{
result.Initialize(dr);
}
return(result);
}
/// <summary>
/// 初始化药品默认用法集合(根据剂型)
/// </summary>
/// <param name="sqlExecutor"></param>
public void InitializeDefaultUsageRange(IDataAccess sqlExecutor)
{
if (sqlExecutor == null)
{
return;
}
DataRow dr = sqlExecutor.GetRecord(PersistentObjectFactory.GetQuerySentenceByName("SelectDefUsageRangeByDruggeryForm")
, String.Format(CultureInfo.CurrentCulture, " DosageID = '{0}'", Form.Code)
, true);
if (dr != null)
{
_defaultUsageRange = dr["UseageID"].ToString();
}
else
{
_defaultUsageRange = "";
}
}
/// <summary>
///
/// </summary>
/// <param name="sqlName"></param>
/// <returns></returns>
protected static string GetQuerySentenceFromXml(string sqlName)
{
return(PersistentObjectFactory.GetQuerySentenceByName(sqlName));
}
