/// <summary>
/// 根据ID获得药品单位信息
/// </summary>
/// <param name="itemid"></param>
/// <param name="itemtype"></param>
/// <returns></returns>
public DataSet GetDwType(int itemid, int itemtype)
{
DataTable dt = BaseLoads.dwlx(itemid, itemtype);
dataSet.Tables["DwType"].Clear();
if (dt == null)
{
return(dataSet);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
dataSet.Tables["DwType"].Rows.Add(dt.Rows[i].ItemArray);
}
return(dataSet);
}
//#region 按输入的医嘱自动选择下一条医嘱的类别
///// <summary>
///// 按输入的医嘱自动选择下一条医嘱的类别
///// </summary>
///// <param name="sign">0＝加载西药和成药 1＝加载中草药 2＝加载项目、治疗，医技，手术 4＝长期医嘱新开 5＝加载项目，治疗，手术</param>
///// <returns></returns>
//private DataTable SelectItems(int sign,int orderkind)
//{
// DataTable tb = null;
// if (sign == 0)
// {
// if (orderkind == 0)
// {
// tb = dictionCopyLong.Clone();
// tb.Clear();
// DataRow[] rows = dictionCopyLong.Select("order_type=1 or order_type=2");
// foreach (DataRow row in rows)
// {
// tb.Rows.Add(row.ItemArray);
// }
// }
// else
// {
// tb = LoadDrugData(ItemType.西药);//加载西药和成药
// }
// }
// if (sign == 1)
// {
// tb = LoadDrugData(ItemType.草药);//加载中草药
// }
// if (sign == 2)
// {
// tb = BaseLoads.LoadItemData(); //加载项目，治疗，医技，手术
// }
// if (sign == 4)//长期医嘱按新开 ...过滤掉中草药和医技项目
// {
// tb = dictionCopyLong.Clone();
// tb.Clear();
// for (int i = 0; i <dictionCopyLong.Rows.Count; i++)
// {
// tb.Rows.Add(dictionCopyLong.Rows[i].ItemArray);
// }
// }
// if (sign == 5)
// {
// tb = BaseLoads.LoadItemDataLong();//加载项目，治疗，手术
// }
// return tb;
//}
//#endregion
#endregion
#region 输入的医嘱自动选择下一条医嘱的类别
/// <summary>
/// 按输入的医嘱自动选择下一条医嘱的类别
/// </summary>
/// <param name="sign">0＝加载西药和成药 1＝加载中草药 2＝加载项目、治疗，医技，手术 4＝长期医嘱新开 5＝加载项目，治疗，手术</param>
/// <returns></returns>
private DataTable SelectItems(ItemType itemtype, OrderType ordertype)
{
DataTable tb = null;
if (itemtype == ItemType.西药)
{
if (ordertype == OrderType.长期医嘱)
{
tb = dictionCopyLong.Clone();
tb.Clear();
DataRow[] rows = dictionCopyLong.Select("order_type=1 or order_type=2");
foreach (DataRow row in rows)
{
tb.Rows.Add(row.ItemArray);
}
}
else
{
tb = LoadDrugData(ItemType.西药);//加载西药和成药
}
}
if (itemtype == ItemType.草药)
{
tb = LoadDrugData(ItemType.草药);//加载中草药
}
if (itemtype == ItemType.所有项目)
{
tb = BaseLoads.LoadItemData(); //加载项目，治疗，医技，手术
}
if (itemtype == ItemType.长嘱新开) //长期医嘱按新开 ...过滤掉中草药和医技项目
{
tb = dictionCopyLong.Clone();
tb.Clear();
for (int i = 0; i < dictionCopyLong.Rows.Count; i++)
{
tb.Rows.Add(dictionCopyLong.Rows[i].ItemArray);
}
}
if (itemtype == ItemType.长嘱项目)
{
tb = BaseLoads.LoadItemDataLong();//加载项目，治疗，手术
}
if (itemtype == ItemType.物资)
{
tb = LoadWz();
}
return(tb);
}
/// <summary>
/// 药房选择
/// </summary>
/// <param name="orderkind"></param>
/// <param name="yfname"></param>
/// <returns></returns>
public DataSet YfSelect(int orderkind, string yfIds)
{
if (orderkind == 0)
{
DataTable tb = BaseLoads.LoadShowCardlong();
dataSet.Tables["ITEM_DICTIONARYLONG"].Clear();
dictionCopyLong.Clear();
//新增判断药房科室
if (yfIds != "-1")
{
DataRow[] dr = tb.Select("execdeptcode in ( " + yfIds + ")");
DataRow[] drItem = tb.Select("order_type >3");
for (int i = 0; i < dr.Length; i++)
{
dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(dr[i].ItemArray);
dictionCopyLong.Rows.Add(dr[i].ItemArray);
}
for (int i = 0; i < drItem.Length; i++)
{
dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(drItem[i].ItemArray);
dictionCopyLong.Rows.Add(drItem[i].ItemArray);
}
}
else
{
for (int i = 0; i < tb.Rows.Count; i++)
{
dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(tb.Rows[i].ItemArray);
dictionCopyLong.Rows.Add(tb.Rows[i].ItemArray);
}
}
}
if (orderkind == 1)
{
DataTable tb = BaseLoads.ShowCard;
dataSet.Tables["ITEM_DICTIONARY"].Clear();
dictionCopy.Clear();
if (yfIds != "-1")
{
DataRow[] dr = tb.Select("execdeptcode in (" + yfIds + ")");
DataRow[] drItem = tb.Select("order_type >3");
for (int i = 0; i < dr.Length; i++)
{
dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(dr[i].ItemArray);
dictionCopy.Rows.Add(dr[i].ItemArray);
}
for (int i = 0; i < drItem.Length; i++)
{
dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(drItem[i].ItemArray);
dictionCopy.Rows.Add(drItem[i].ItemArray);
}
}
else
{
tb = BaseLoads.ShowCard;
for (int i = 0; i < tb.Rows.Count; i++)
{
dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(tb.Rows[i].ItemArray);
dictionCopy.Rows.Add(tb.Rows[i].ItemArray);
}
}
}
return(dataSet);
//if (orderkind == 0)
//{
// DataTable tb = BaseLoads.LoadShowCardlong();
// dataSet.Tables["ITEM_DICTIONARYLONG"].Clear();
// dictionCopyLong.Clear();
// //新增判断药房科室
// if (yfname != "全部药房")
// {
// DataRow[] dr = tb.Select("execdeptname = '" + yfname + "'");
// DataRow[] drItem = tb.Select("order_type >3");
// for (int i = 0; i < dr.Length; i++)
// {
// dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(dr[i].ItemArray);
// dictionCopyLong.Rows.Add(dr[i].ItemArray);
// }
// for (int i = 0; i < drItem.Length; i++)
// {
// dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(drItem[i].ItemArray);
// dictionCopyLong.Rows.Add(drItem[i].ItemArray);
// }
// }
// else
// {
// for (int i = 0; i < tb.Rows.Count; i++)
// {
// dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Add(tb.Rows[i].ItemArray);
// dictionCopyLong.Rows.Add(tb.Rows[i].ItemArray);
// }
// }
//}
//if (orderkind == 1)
//{
// DataTable tb = BaseLoads.ShowCard;
// dataSet.Tables["ITEM_DICTIONARY"].Clear();
// dictionCopy.Clear();
// if (yfname != "全部药房")
// {
// DataRow[] dr = tb.Select("execdeptname = '" + yfname + "'");
// DataRow[] drItem = tb.Select("order_type >3");
// for (int i = 0; i < dr.Length; i++)
// {
// dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(dr[i].ItemArray);
// dictionCopy.Rows.Add(dr[i].ItemArray);
// }
// for (int i = 0; i < drItem.Length; i++)
// {
// dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(drItem[i].ItemArray);
// dictionCopy.Rows.Add(drItem[i].ItemArray);
// }
// }
// else
// {
// tb = BaseLoads.ShowCard;
// for (int i = 0; i < tb.Rows.Count; i++)
// {
// dataSet.Tables["ITEM_DICTIONARY"].Rows.Add(tb.Rows[i].ItemArray);
// dictionCopy.Rows.Add(tb.Rows[i].ItemArray);
// }
// }
//}
//return dataSet;
}
/// <summary>
/// 获得基础数据表的信息
/// </summary>
/// <returns></returns>
public DataSet LoadBaseINFO()
{
if (dataSet != null && dataSet.Tables.Count > 0) //20100628.2.05
{
return(dataSet);
}
DataTable tb = null;
tb = BaseLoads.LoadShowCard(1);
tb.TableName = "ITEM_DICTIONARY";
if (dataSet.Tables.Contains("ITEM_DICTIONARY"))
{
dataSet.Tables.Remove("ITEM_DICTIONARY");
}
dataSet.Tables.Add(tb);
dictionCopy = dataSet.Tables["ITEM_DICTIONARY"].Clone();
dictionCopy.Clear();
itemdrugs = dataSet.Tables["ITEM_DICTIONARY"].Clone();
itemdrugs.Clear();
for (int i = 0; i < dataSet.Tables["ITEM_DICTIONARY"].Rows.Count; i++)
{
dictionCopy.Rows.Add(dataSet.Tables["ITEM_DICTIONARY"].Rows[i].ItemArray);
itemdrugs.Rows.Add(dataSet.Tables["ITEM_DICTIONARY"].Rows[i].ItemArray);
}
tb = BaseLoads.LoadShowCardlong(); //长期医嘱新开选项卡
tb.TableName = "ITEM_DICTIONARYLONG";
if (dataSet.Tables.Contains("ITEM_DICTIONARYLONG"))
{
dataSet.Tables.Remove("ITEM_DICTIONARYLONG");
}
dataSet.Tables.Add(tb);
dictionCopyLong = dataSet.Tables["ITEM_DICTIONARYLONG"].Clone();
dictionCopyLong.Clear();
for (int i = 0; i < dataSet.Tables["ITEM_DICTIONARYLONG"].Rows.Count; i++)
{
dictionCopyLong.Rows.Add(dataSet.Tables["ITEM_DICTIONARYLONG"].Rows[i].ItemArray);
}
tb = BaseLoads.LoadFrequency();
tb.TableName = "Frequency";
if (dataSet.Tables.Contains("Frequency"))
{
dataSet.Tables.Remove("Frequency");
}
dataSet.Tables.Add(tb);
tb = BaseLoads.LoadUsage();
tb.TableName = "Usage";
if (dataSet.Tables.Contains("Usage"))
{
dataSet.Tables.Remove("Usage");
}
dataSet.Tables.Add(tb);
tb = BaseLoads.LoadEntrust();
tb.TableName = "Entrust";
if (dataSet.Tables.Contains("Entrust"))
{
dataSet.Tables.Remove("Entrust");
}
dataSet.Tables.Add(tb);
tb = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetUserData(HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.EmpType.医生);
tb.TableName = "User";
if (dataSet.Tables.Contains("User"))
{
dataSet.Tables.Remove("User");
}
dataSet.Tables.Add(tb);
tb = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetDeptData(HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.DeptType.住院, HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.DeptType2.临床);
tb.TableName = "Dept";
if (dataSet.Tables.Contains("Dept"))
{
dataSet.Tables.Remove("Dept");
}
dataSet.Tables.Add(tb);
tb = BaseLoads.dwlx(-1, -1);
tb.TableName = "DwType";
if (dataSet.Tables.Contains("DwType"))
{
dataSet.Tables.Remove("DwType");
}
dataSet.Tables.Add(tb);
tb = BaseLoads.LoadUnitDic();
tb.TableName = "UnitDic";
if (dataSet.Tables.Contains("UnitDic"))
{
dataSet.Tables.Remove("UnitDic");
}
dataSet.Tables.Add(tb);
return(dataSet);
}
