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