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