Esempio n. 1
0
        public frmzz(Guid ghxxid, Fz_Zq zq)//,bool bhs
        {
            InitializeComponent();
            // Bhs = bhs;
            _CurrentZq     = zq;
            _CurrentGhxxid = ghxxid;
//            string ssql = @"select brxm 姓名,dbo.FUN_ZY_SEEKSEXNAME(xb) 性别,dbo.fun_zy_age(csrq,3,getdate()) 年龄,ghsj 挂号时间,blh 门诊号,
//		            dbo.fun_getdeptname(ghks) 挂号科室,type_name 挂号级别,dbo.fun_getempname(ghys) 挂号医生,a.ghxxid,ghks,ghys,ghjb,pdxh
//                from mz_ghxx a inner join yy_brxx b on a.brxxid=b.brxxid
//	            left join yy_kdjb c on a.kdjid=c.kdjid left join jc_doctor_type d
//	            on a.ghjb= d.type_id where ghxxid='"+ghxxid+"' and bqxghbz=0 ";
//            DataTable tb = InstanceForm.BDatabase.GetDataTable(ssql);
            dt_ghxx = MZHS_FZJL.GetMzGhxxToZz(ghxxid, InstanceForm.BDatabase);
            if (dt_ghxx.Rows.Count == 0)
            {
                return;
            }
            lblbrxm.Text = Convertor.IsNull(dt_ghxx.Rows[0]["姓名"], "");
            lblxb.Text   = Convertor.IsNull(dt_ghxx.Rows[0]["性别"], "");
            lblnl.Text   = Convertor.IsNull(dt_ghxx.Rows[0]["年龄"], "");
            lblblh.Text  = Convertor.IsNull(dt_ghxx.Rows[0]["门诊号"], "");
            lblghsj.Text = Convertor.IsNull(dt_ghxx.Rows[0]["挂号时间"], "");
            lblghks.Text = Convertor.IsNull(dt_ghxx.Rows[0]["挂号科室"], "");
            lblghks.Tag  = Convertor.IsNull(dt_ghxx.Rows[0]["ghks"], "");

            lblghys.Text = Convertor.IsNull(dt_ghxx.Rows[0]["挂号医生"], "");
            lblghys.Tag  = Convertor.IsNull(dt_ghxx.Rows[0]["ghys"], "");

            lblghjb.Text = Convertor.IsNull(dt_ghxx.Rows[0]["挂号级别"], "");
            lblghjb.Tag  = Convertor.IsNull(dt_ghxx.Rows[0]["ghjb"], "");
            // if (bhs == true) cmbks.Enabled = false;
        }