/// <summary> /// 显示药品列表 不显示药库停用的药品 与药房是否停用无关 /// </summary> public virtual void ShowPharmacyList(string drugType) { Neusoft.NFC.Interface.Classes.Function.ShowWaitForm("正在检索药品信息..."); Application.DoEvents(); try { Neusoft.NFC.Management.DataBaseManger databaseManager = new Neusoft.NFC.Management.DataBaseManger(); DataSet dataSet = new DataSet(); string[] sqlIndex = new string[2] { "Pharmacy.Item.ValibInfo", "Preparation.Item.GetList.QueryByType" }; databaseManager.ExecQuery(sqlIndex, ref dataSet, drugType); if (dataSet == null) { MessageBox.Show("检索列表数据发生错误\n" + databaseManager.Err); return; } this.filterField = new string[7] { "SPELL_CODE", "WB_CODE", "REGULAR_NAME", "REGULAR_SPELL", "REGULAR_WB", "CUSTOM_CODE", "TRADE_NAME" }; this.DataTable = dataSet.Tables[0]; this.SetpharmacyFormat(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); } }
/// <summary> /// 检索程序中需要的列表 /// </summary> /// <param name="sqlIndex">检索的SQL语句在XML中的索引数组 第一位为select索引 其他为where索引</param> /// <param name="filterField">用于对该列表进行检索的字段,由sql语句检索的数据内选择</param> /// <param name="formatStr">对sql语句进行格式化的数据</param> public void ShowInfoList(string[] sqlIndex, string[] filterField, params string[] formatStr) { Neusoft.NFC.Interface.Classes.Function.ShowWaitForm("正在检索数据 请稍候....."); Application.DoEvents(); try { this.DataAutoCellType = false; this.DataAutoHeading = false; this.DataAutoWidth = false; Neusoft.NFC.Management.DataBaseManger databaseManager = new Neusoft.NFC.Management.DataBaseManger(); DataSet dataSet = new DataSet(); databaseManager.ExecQuery(sqlIndex, ref dataSet, formatStr); if (dataSet == null) { MessageBox.Show("检索列表数据发生错误\n" + databaseManager.Err); return; } this.DataTable = dataSet.Tables[0]; this.FilterField = filterField; } catch (Exception ex) { MessageBox.Show("检索列表数据发生错误\n" + ex.Message); } finally { Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); } }
public string GetRuleSequence() { Neusoft.NFC.Management.DataBaseManger manager = new Neusoft.NFC.Management.DataBaseManger(); this.SetDB(manager); return(manager.GetSequence("EPR.CaseWriteRule.GetRuleCodeSequence")); }
/// <summary> /// 获得 /// </summary> /// <param name="id"></param> /// <returns></returns> public virtual string GetSetting(string id) { string sql = "select xml from emr_setting where id='{0}'"; sql = string.Format(sql, id); Neusoft.NFC.Management.DataBaseManger manager = new Neusoft.NFC.Management.DataBaseManger(); this.SetDB(manager); return(manager.ExecSqlReturnOne(sql)); }
/// <summary> /// 保存 /// </summary> /// <param name="obj"></param> /// <param name="xml"></param> /// <returns></returns> public virtual int SaveSetting(Neusoft.NFC.Object.NeuObject obj, string xml) { string sqlInsert = "INSERT INTO emr_setting (id,name,memo) VALUES('{0}','{1}','{2}') "; string sqlDelete = "delete emr_setting where id='{0}'"; string update = string.Format("update emr_setting set xml=:a where id='{0}'", obj.ID); Neusoft.NFC.Management.DataBaseManger manager = new Neusoft.NFC.Management.DataBaseManger(); this.SetDB(manager); manager.ExecNoQuery(sqlDelete, obj.ID); manager.ExecNoQuery(sqlInsert, obj.ID, obj.Name, obj.Memo); return(manager.InputLong(update, xml)); }
/// <summary> /// 树管理类初始化 /// </summary> /// <param name="addTree">数据添加树 向该树内添加节点</param> /// <param name="operTree">数据操作树 对该树内数据进行操作</param> /// <param name="nextTree">数据后继树 数据操作后移动目的树</param> /// <param name="funMode">功能模块类型</param> /// <param name="operDateState">数据添加树节点数据状态</param> internal ClinicTreeManager(TabPage addTab, TreeView addTree, TabPage operTab, TreeView operTree, TabPage nextTab, TreeView nextTree) { this.AddTab = addTab; this.AddTree = addTree; this.OperTab = operTab; this.OperTree = operTree; this.NextTab = nextTab; this.NextTree = nextTree; Neusoft.NFC.Management.DataBaseManger dataBaseManager = new Neusoft.NFC.Management.DataBaseManger(); this.minQueryDate = dataBaseManager.GetDateTimeFromSysDateTime().Date; }
/// <summary> /// 显示库存药品列表 不显示药库停用的药品 无药房是否停用无关 /// </summary> /// <param name="deptCode">库房编码</param> /// <param name="isBatch">是否按批号管理</param> public virtual void ShowDeptStorage(string deptCode, bool isBatch) { Neusoft.NFC.Interface.Classes.Function.ShowWaitForm("正在检索库存药品信息..."); Application.DoEvents(); try { Neusoft.NFC.Management.DataBaseManger databaseManager = new Neusoft.NFC.Management.DataBaseManger(); DataSet dataSet = new DataSet(); string sqlIndex; if (isBatch) { sqlIndex = "Pharmacy.Item.GetStorageListByBatch"; } else { sqlIndex = "Pharmacy.Item.GetStorageListNoBatch"; } databaseManager.ExecQuery(sqlIndex, ref dataSet, deptCode); if (dataSet == null) { MessageBox.Show("检索列表数据发生错误\n" + databaseManager.Err); return; } this.filterField = new string[3] { "SPELL_CODE", "WB_CODE", "TRADE_NAME" }; this.DataTable = dataSet.Tables[0]; //使用控件默认的显示格式 this.SetFormatForStorage(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); } }