//高血压随访记录历史表 关联传参调查询的方法 private void querypBasicInfo() { this.dataGridView1.DataSource = null; DataTable dt = pBasicInfo.queryPersonalBasicInfo(pCa, time1, time2); this.dataGridView1.DataSource = dt; this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[1].HeaderCell.Value = "姓名"; this.dataGridView1.Columns[2].HeaderCell.Value = "身份证号"; this.dataGridView1.Columns[3].HeaderCell.Value = "创建人"; this.dataGridView1.Columns[4].HeaderCell.Value = "创建时间"; this.dataGridView1.Columns[5].HeaderCell.Value = "责任医生"; this.dataGridView1.Columns[6].HeaderCell.Value = "数据状态"; this.dataGridView1.ReadOnly = true; this.dataGridView1.RowsDefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; for (int i = 0; i < this.dataGridView1.Columns.Count; i++) { this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } }
//个人基本建档记录历史表 关联传参调查询的方法 private void querypBasicInfo() { time1 = this.dateTimePicker1.Text.ToString() + " 00:00:00"; //开始时间 time2 = this.dateTimePicker2.Text.ToString() + " 23:59:59"; //结束时间 this.dataGridView1.DataSource = null; LoadingHelper.myCaption = "正在查询..."; LoadingHelper.myLabel = "正在查询数据..."; LoadingHelper.ShowLoadingScreen(); Thread.Sleep(50); try { DataTable dt = pBasicInfo.queryPersonalBasicInfo(pCa, time1, time2, xcuncode); //这里处理下对应的记录 DataTable dtfinished = CreateDataTable(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dtfinished.NewRow(); dr[0] = dt.Rows[i][0].ToString(); dr[1] = dt.Rows[i][1].ToString(); dr[2] = dt.Rows[i][2].ToString(); dr[3] = dt.Rows[i][3].ToString(); #region 处理特殊标签 String _teshubiaoqian = ""; String _tmp = dt.Rows[i]["age"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) >= 65) { _teshubiaoqian = "老"; } else { if (int.Parse(_tmp) <= 6) { _teshubiaoqian = "儿童"; } } _tmp = dt.Rows[i]["is_gravida"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 孕"; } _tmp = dt.Rows[i]["is_hypertension"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 高"; } _tmp = dt.Rows[i]["is_diabetes"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 糖"; } _tmp = dt.Rows[i]["is_psychosis"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 精"; } _tmp = dt.Rows[i]["is_tuberculosis"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 结"; } _tmp = dt.Rows[i]["is_poor"].ToString(); if (_tmp == "") { _tmp = "0"; } if (int.Parse(_tmp) != 0) { _teshubiaoqian = _teshubiaoqian + " 贫"; } #endregion dr[4] = _teshubiaoqian.Trim(); dr[5] = dt.Rows[i][4].ToString(); dr[6] = dt.Rows[i][5].ToString(); dr[7] = dt.Rows[i][6].ToString(); dtfinished.Rows.Add(dr); } this.dataGridView1.DataSource = dtfinished; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("微软雅黑", 12, System.Drawing.FontStyle.Regular); this.dataGridView1.Columns[0].Visible = false; this.dataGridView1.Columns[1].HeaderCell.Value = "姓名"; this.dataGridView1.Columns[2].HeaderCell.Value = "档案编号"; this.dataGridView1.Columns[3].HeaderCell.Value = "身份证号"; this.dataGridView1.Columns[4].HeaderCell.Value = "重点人群标签"; this.dataGridView1.Columns[5].HeaderCell.Value = "创建人"; this.dataGridView1.Columns[6].HeaderCell.Value = "创建时间"; this.dataGridView1.Columns[7].HeaderCell.Value = "责任医生"; this.dataGridView1.ReadOnly = true; this.dataGridView1.RowsDefaultCellStyle.ForeColor = Color.Black; this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; for (int i = 0; i < this.dataGridView1.Columns.Count; i++) { this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } LoadingHelper.CloseForm(); } catch (Exception ex) { LoadingHelper.CloseForm(); MessageBox.Show("出错,请联系请联系管理员!" + ex.Message + "/r/n" + ex.StackTrace); } }