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