private void bt_select_Click(object sender, EventArgs e) { if (dtp_begin.Value > dtp_end.Value) { MessageBox.Show("开始日期不能大于结束日期!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = dtp_begin; return; } if (txt_tjdw.Text == "") { txt_tjdw.Tag = ""; } string str_dwbh = ""; if (txt_tjdw.Tag.ToString().Trim() != "") { str_dwbh = txt_tjdw.Tag.ToString().Trim().Substring(0, 4); } string str_bmbh = txt_tjdw.Tag.ToString().Trim(); if (str_bmbh.Length == 4) { str_bmbh = ""; } string str_xb = "%"; if (!object.Equals(null, cmb_xb.SelectedValue)) { str_xb = cmb_xb.SelectedValue.ToString().Trim(); } string str_zjzt = "0"; if (cmb_zjzt.Text == "已总检") { str_zjzt = "2"; } else if (cmb_zjzt.Text == "未总检") { str_zjzt = "1"; } else//全部 { str_zjzt = "0"; } tjdj.tjdjBiz tjdjbiz = new tjdj.tjdjBiz(); dgv_tjdjb.DataSource = tjdjbiz.Get_TJ_TJDJB(dtp_begin.Value.ToString("yyyy-MM-dd"), dtp_end.Value.AddDays(1).ToString("yyyy-MM-dd"), txt_tjbh1.Text.Trim(), txt_tjbh2.Text.Trim(), txt_xm.Text.Trim(), str_xb, str_dwbh, str_bmbh, str_zjzt); ChargeColor(); }
void JLMXB_DataBind(DataGridViewRow dgr) { string str_zhxm = dgr.Cells["zhxm"].Value.ToString().Trim(); string str_xh = dgr.Cells["xh"].Value.ToString().Trim(); string str_xmlx = dgr.Cells["xmlx"].Value.ToString().Trim(); //0检验科 1医生检查 2功能检查 string str_lxbh = dgr.Cells["lxbh"].Value.ToString().Trim(); //类型编号,科室ID dgv_tjjlmxb.DataSource = tjjgbiz.Get_TJ_TJJLMXB(str_xh, str_zhxm); //--------------------- dgv_tjjlmxb.Tag = str_xmlx; //Tag保存项目类型值----------------------------------------------------------------------------------- if (str_xmlx == "0") { dgv_tjjlmxb.Columns["tjjlmxb_jg"].Width = 80; dgv_tjjlmxb.Columns["tjjlmxb_dw"].Visible = true; dgv_tjjlmxb.Columns["tjjlmxb_ckxx"].Visible = true; dgv_tjjlmxb.Columns["tjjlmxb_cksx"].Visible = true; } if (str_xmlx == "1") { dgv_tjjlmxb.Columns["tjjlmxb_jg"].Width = 200; dgv_tjjlmxb.Columns["tjjlmxb_dw"].Visible = true; dgv_tjjlmxb.Columns["tjjlmxb_ckxx"].Visible = false; dgv_tjjlmxb.Columns["tjjlmxb_cksx"].Visible = false; } if (str_xmlx == "2") { dgv_tjjlmxb.Columns["tjjlmxb_jg"].Width = 300; dgv_tjjlmxb.Columns["tjjlmxb_dw"].Visible = false; dgv_tjjlmxb.Columns["tjjlmxb_ckxx"].Visible = false; dgv_tjjlmxb.Columns["tjjlmxb_cksx"].Visible = false; } //1初始化参考值 2获取该项疾病记录 3异常情况,结果以红色字体显示 foreach (DataGridViewRow dgrow in dgv_tjjlmxb.Rows) { string str_tjlx = dgrow.Cells["tjjlmxb_tjlx"].Value.ToString().Trim(); string str_tjxm = dgrow.Cells["tjjlmxb_tjxm"].Value.ToString().Trim(); //检验科获取参考值 if (str_xmlx == "0") { int nl = 0; try { nl = Convert.ToInt32(str_nl); } catch { } DataTable dt_gz = new tjdj.tjdjBiz().Get_TJ_TJDJB(str_tjbh, str_tjcs); string gz = ""; if (dt_gz.Rows.Count > 0) { gz = dt_gz.Rows[0]["gz"].ToString().Trim(); } DataTable dtCkz = tjjgbiz.Get_pro_get_ckz(str_tjlx, str_tjxm, str_xb, nl, gz); if (dtCkz.Rows.Count <= 0) { continue; } string str_ckz = dtCkz.Rows[0]["ckz"].ToString().Trim(); if (str_ckz == "") { continue; //获取值为空跳过,设置有问题 } dgrow.Cells["tjjlmxb_ckxx"].Value = str_ckz.Split('—')[0]; dgrow.Cells["tjjlmxb_cksx"].Value = str_ckz.Split('—')[1]; dgrow.Cells["tjjlmxb_ckz"].Value = str_ckz; dgrow.Cells["spy"].Value = dtCkz.Rows[0]["spy"].ToString().Trim(); dgrow.Cells["xpy"].Value = dtCkz.Rows[0]["xpy"].ToString().Trim(); } //异常情况,结果以红色字体显示 string str_sfyx = dgrow.Cells["tjjlmxb_sfyx"].Value.ToString().Trim(); if (str_sfyx == "1") { dgrow.Cells["tjjlmxb_jg"].Style.ForeColor = Color.Red; } } rtb_xj.Text = ""; DataTable dt = tjjgbiz.Get_TJ_TJJLB(str_tjbh, str_tjcs, str_xh, str_zhxm); try { dtp_jcrq.Value = Convert.ToDateTime(dt.Rows[0]["jcrq"]); cmb_czy.SelectedValue = dt.Rows[0]["czy"].ToString().Trim(); cmb_jcys.SelectedValue = dt.Rows[0]["jcys"].ToString().Trim(); rtb_xj.Text = dt.Rows[0]["xj"].ToString().Trim(); } catch { } }