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