/// <summary>
/// 初始化数据
/// </summary>
public void m_mthInitData()
{
//床位费
clsListViewColumns_VO[] p_objLsvColumnsArr = new clsListViewColumns_VO[5] {
new clsListViewColumns_VO("编码", "itemcode_vchr", HorizontalAlignment.Left, 70),
new clsListViewColumns_VO("拼音码", "itempycode_chr", HorizontalAlignment.Left, 70),
new clsListViewColumns_VO("五笔码", "itemwbcode_chr", HorizontalAlignment.Left, 70),
new clsListViewColumns_VO("费用名称", "itemname_vchr", HorizontalAlignment.Left, 220),
new clsListViewColumns_VO("金额", "itemprice_mny", HorizontalAlignment.Left, 50)
};
m_objViewer.m_txtBedMoney.m_mthInitListView(p_objLsvColumnsArr);
m_objViewer.m_txtBedMoney.m_strSQL = @"SELECT t1.itemid_chr, t1.itemname_vchr, t1.itemprice_mny, t1.itempycode_chr,
t1.itemwbcode_chr, t1.itemcode_vchr,
TRIM (t1.itemname_vchr) || ' ' || t1.itemprice_mny
|| '(元)' AS charename
FROM t_bse_chargeitem t1, t_bse_bih_specordercate t2
WHERE t1.itemipinvtype_chr = t2.bedchargecate AND t1.ifstop_int = 0";
m_objViewer.m_txtBedMoney.m_strFindFieldsArr = new string[4] {
"itempycode_chr", "itemwbcode_chr", "itemname_vchr", "itemcode_vchr"
};
m_objViewer.m_txtBedMoney.m_mthGetData();
//空调费
m_objViewer.m_txtAirCondistionMoney.m_mthInitListView(p_objLsvColumnsArr);
m_objViewer.m_txtAirCondistionMoney.m_strSQL = @"SELECT t1.itemid_chr, t1.itemname_vchr, t1.itemprice_mny, t1.itempycode_chr,
t1.itemwbcode_chr, t1.itemcode_vchr,
TRIM (t1.itemname_vchr) || ' ' || t1.itemprice_mny
|| '(元)' AS charename
FROM t_bse_chargeitem t1
WHERE t1.ifstop_int = 0 AND itemname_vchr LIKE '空调费%'";
m_objViewer.m_txtAirCondistionMoney.m_strFindFieldsArr = new string[4] {
"itempycode_chr", "itemwbcode_chr", "itemname_vchr", "itemcode_vchr"
};
m_objViewer.m_txtAirCondistionMoney.m_mthGetData();
}
private void frmBabyRegisterlReport_Shown(object sender, EventArgs e)
{
clsListViewColumns_VO[] m_objColumnsArr = new clsListViewColumns_VO[] {
new clsListViewColumns_VO("编号", "code_vchr", HorizontalAlignment.Left, 50),
new clsListViewColumns_VO("拼音码", "pycode_chr", HorizontalAlignment.Left, 60),
new clsListViewColumns_VO("名称", "deptname_vchr", HorizontalAlignment.Left, 70)
};
m_txtAREAID_CHR.m_mthInitListView(m_objColumnsArr);
m_txtAREAID_CHR.m_strSQL = @"SELECT '0' AS deptid_chr, '全院' AS deptname_vchr, 'QY' AS pycode_chr,
'0' AS code_vchr
FROM DUAL
UNION ALL
SELECT deptid_chr, deptname_vchr, pycode_chr, code_vchr
FROM t_bse_deptdesc t1
WHERE TRIM (attributeid) = '0000003' AND status_int = 1
ORDER BY code_vchr";
m_txtAREAID_CHR.m_mthGetData();
m_txtAREAID_CHR.Tag = "0";
m_txtAREAID_CHR.Text = "全院";
}
