/// <summary> /// /// </summary> public void Query() { Neusoft.NFC.Interface.Classes.Function.ShowWaitForm("正在进行查询...请稍候"); Application.DoEvents(); string exeSql = ""; if (this.ckAll.Checked) //全部药品 { exeSql = string.Format(this.sql1, stroeageCode); } else { if (this.cmbDrug.Tag != null && this.cmbDrug.Tag.ToString() != "") { exeSql = string.Format(this.sql2, stroeageCode, this.cmbDrug.Tag.ToString()); } else { Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); return; } } Neusoft.NFC.Management.DataBaseManger dataManager = new Neusoft.NFC.Management.DataBaseManger(); DataSet ds = new DataSet(); if (dataManager.ExecQuery(exeSql, ref ds) == -1) { Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg("执行Sql语句发生错误" + dataManager.Err)); return; } if (ds != null && ds.Tables.Count > 0) { foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { if (ds.Tables[0].Columns.Contains("库存科室")) { dr["库存科室"] = this.deptHelper.GetName(dr["库存科室"].ToString()); } } } this.dv = new DataView(ds.Tables[0]); this.neuSpread1_Sheet1.DataSource = dv; this.SetFormat(); if (this.neuSpread1.ActiveSheet != this.neuSpread1_Sheet1) { this.neuSpread1.ActiveSheet = this.neuSpread1_Sheet1; } Neusoft.NFC.Interface.Classes.Function.HideWaitForm(); }
/// <summary> /// 初始化 /// </summary> private void Init() { // Neusoft.HISFC.Management.Pharmacy.Item itemManager = new Neusoft.HISFC.Management.Pharmacy.Item(); // List<Neusoft.HISFC.Object.Pharmacy.Item> itemList = itemManager.QueryItemList(true); //this.cmbDrug.AddItems(new ArrayList(itemList.ToArray())); Neusoft.HISFC.Management.Manager.Department deptManager = new Neusoft.HISFC.Management.Manager.Department(); ArrayList alDept = deptManager.GetDeptmentAll(); this.deptHelper = new Neusoft.NFC.Public.ObjectHelper(alDept); string operCode = string.Empty; Neusoft.NFC.Management.DataBaseManger data = new Neusoft.NFC.Management.DataBaseManger(); operCode = ((Neusoft.HISFC.Object.Base.Employee)data.Operator).ID; //取该操作员所在科室即可 stroeageCode = ((Neusoft.HISFC.Object.Base.Employee)data.Operator).Dept.ID; #region 加载Sql // this.sql1 = @" //select s.trade_name 药品名称,s.specs 规格,t.drug_dept_code 库存科室, // round(t.store_sum / t.pack_qty,2) 库存量,s.pack_unit 单位, // s.spell_code 拼音码,s.wb_code 五笔码,s.custom_code 自定义码, // t.drug_code 药品编码,t.drug_dept_code 库存编码,t.valid_state 停用 //from pha_com_stockinfo t,pha_com_baseinfo s //where t.drug_code = s.drug_code"; //and t.storage_code= '{stroeageCode}' this.sql1 = @" select s.item_name 物品名称,s.specs 规格,t.store_num 库存,t.price 单价,t.stat_unit 包装单位,t.store_cost 库存金额,t.valid_state 有效标志,s.item_code,s.kind_code,s.spell_code 拼音码,t.place_code from log_mat_baseinfo s,log_mat_stock t where t.item_code=s.item_code and t.storage_code= '{0}'" ; this.sql2 = @" select s.item_name 物品名称,s.item_code,s.kind_code,s.spell_code 拼音码,s.specs 规格,t.store_num 库存,t.price 单价,t.stat_unit 包装单位,t.store_cost 库存金额,,t.valid_state 有效标志s.item_code,s.kind_code,s.spell_code 拼音码,t.place_code from log_mat_baseinfo s,log_mat_stock t where t.item_code=s.item_code and t.storage_code= '{0}' and t.item_code = '{1}'"; #endregion this.neuSpread1_Sheet1.DefaultStyle.Locked = true; //this.neuSpread1_Sheet2.DefaultStyle.Locked = true; }
/// <summary> /// 初始化 /// </summary> public virtual void Init() { Neusoft.NFC.Management.DataBaseManger dataManager = new Neusoft.NFC.Management.DataBaseManger(); DateTime sysTime = dataManager.GetDateTimeFromSysDateTime(); if (this.rbOut.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.outIntervalDays); } if (this.rbIn.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.inIntervalDays); } if (this.rbStock.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.stockIntervalDays); } this.dtpEnd.Value = sysTime; #region 加载入出库/采购状态集 this.hsInOutState = new System.Collections.Hashtable(); this.hsInOutState.Add("0", "申请"); this.hsInOutState.Add("1", "审批"); this.hsInOutState.Add("2", "核准"); this.hsStockState = new System.Collections.Hashtable(); this.hsStockState.Add("0", "计划"); this.hsStockState.Add("1", "采购"); this.hsStockState.Add("2", "审核"); this.hsStockState.Add("3", "入库"); #endregion this.IsShowTypeCheck = false; this.Clear(); }