Exemple #1
0
        private void btnFunNurse_Click(object sender, System.EventArgs e)
        {
            string        sql     = "select b.employee_id as id,' ' as code,b.name,py_code,wb_code from jc_role_nurse a inner join jc_employee_property b on a.employee_id=b.employee_id where b.delete_bit=0 order by a.employee_id";
            FrmSelectCard fSelect = new FrmSelectCard(sql, 1);

            fSelect.ShowDialog();
            if (fSelect.FindResult)
            {
                this.txtFunNurse.Text = fSelect.SelectName;
                this.txtFunNurse.Tag  = fSelect.SelectID;
            }
        }
Exemple #2
0
        private void btnLinkFee_Click(object sender, System.EventArgs e)
        {
            string sql = "select  c.jgbm,b.order_id as ID,b.d_code as Code,order_name as name,b.py_code ,b.wb_code,c.price";

            sql += " from jc_hoi_hdi a inner join jc_hoitemdiction b on a.hoitem_id=b.order_id";
            sql += " inner join vi_jc_items c on a.hditem_id=c.itemid and a.tcid=c.tcid";
            sql += " inner join Jc_cwggd t on a.HOITEM_ID=t.Hoitem_id and t.delete_bit=0";
            //sql += " inner join JC_HOI_DEPT d on b.ORDER_ID=d.ORDER_ID ";
            //sql += " where b.delete_bit=0 and c.bigitemcode='" + (new SystemCfg(7029)).Config.Trim() + "' and d.EXEC_DEPT='" + InstanceForm.BCurrentDept.DeptId + "' order by b.order_id";

            sql += " where b.delete_bit=0 and c.bigitemcode='" + (new SystemCfg(7029)).Config.Trim() + "' order by order_name,b.order_id";
            FrmSelectCard fSelect = new FrmSelectCard(sql);

            fSelect.ShowDialog();
            if (fSelect.FindResult)
            {
                this.txtLinkFee.Text = fSelect.SelectName;
                this.txtLinkFee.Tag  = fSelect.SelectID;
            }
        }