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