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