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; }
public FrmKzqzz(string _blh, Fz_Zq _zq) { InitializeComponent(); blh = _blh; _CurrentZq = _zq; }