private void loadDataGridView() { try { ParameterEx[] parameter = new ParameterEx[7]; parameter[0].Text = "@RQ1"; parameter[0].Value = dtpTjKs.Value.Date.ToString("yyyy-MM-dd") + " 00:00:00"; parameter[1].Text = "@RQ2"; parameter[1].Value = dtpTjJs.Value.Date.ToString("yyyy-MM-dd") + " 23:59:59"; parameter[2].Text = "@KSDM"; parameter[2].Value = txtDept.Tag == null ? 0 : txtDept.Tag; parameter[3].Text = "@YSDM"; parameter[3].Value = txtUser.Tag == null ? 0 : txtUser.Tag; parameter[4].Text = "@jgbm"; parameter[4].Value = cmbjgbm.SelectedValue.ToString(); parameter[5].Text = "@ERR_CODE"; parameter[5].Value = 0; parameter[6].Text = "@ERR_TEXT"; parameter[6].Value = ""; System.Data.DataTable dt = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZYS_SELECT_INFOTJ", parameter, 100); PubStaticFun.SetDataGridIncreaseRowNumber(dt, "序号"); dataGridView1.DataSource = dt; //dataGridView1.Columns["NO"].HeaderText = "序号"; //dataGridView1.Columns["序号"].Width = 35; //dataGridView1.Columns["医生"].Width = 55; if (dataGridView1.Columns.Contains("YSDM") == true) { dataGridView1.Columns["ysdm"].Visible = false; } //dataGridView1.Columns["医生"].HeaderText = "医生"; //dataGridView1.Columns["医生"].Width = 55; //dataGridView1.Columns["ZJE"].HeaderText = "总金额"; //dataGridView1.Columns["ZJE"].Width = 65; //dataGridView1.Columns["YPJE"].HeaderText = "药品金额"; //dataGridView1.Columns["YPJE"].Width = 65; //dataGridView1.Columns["YPBFB"].HeaderText = "药品百分比"; //dataGridView1.Columns["YPBFB"].Width = 65; //dataGridView1.Columns["ITEMJE"].HeaderText = "项目金额"; //dataGridView1.Columns["ITEMJE"].Width = 65; //dataGridView1.Columns["XMBFB"].HeaderText = "项目百分比"; //dataGridView1.Columns["XMBFB"].Width = 65; //dataGridView1.Columns["CFLS"].HeaderText = "处方流失(张)"; //dataGridView1.Columns["CFLS"].Width = 65; //dataGridView1.Columns["CFLSJE"].HeaderText = "处方流失金额(元)"; //dataGridView1.Columns["CFLSJE"].Width = 65; //dataGridView1.Columns["JZRC"].HeaderText = "接诊人次"; //dataGridView1.Columns["JZRC"].Width = 55; //dataGridView1.Columns["ZYZ"].HeaderText = "住院证"; //dataGridView1.Columns["ZYZ"].Width = 55; foreach (DataGridViewColumn column in dataGridView1.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btntj_Click(object sender, EventArgs e) { System.Data.DataTable dt = new DataTable(); if (radioButtonmz.Checked) { ParameterEx[] parameter = new ParameterEx[3]; parameter[0].Text = "@RQ1"; parameter[0].Value = dtpbegin.Value.Date.ToString("yyyy-MM-dd") + " 00:00:00"; parameter[1].Text = "@RQ2"; parameter[1].Value = dtpEnd.Value.Date.ToString("yyyy-MM-dd") + " 23:59:59"; parameter[2].Text = "@jgbm"; parameter[2].Value = InstanceForm.BCurrentDept.Jgbm; dt = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZYS_YPSYBL", parameter, 100); } else { ParameterEx[] parameter = new ParameterEx[4]; parameter[0].Text = "@RQ1"; parameter[0].Value = dtpbegin.Value.Date.ToString("yyyy-MM-dd") + " 00:00:00"; parameter[1].Text = "@RQ2"; parameter[1].Value = dtpEnd.Value.Date.ToString("yyyy-MM-dd") + " 23:59:59"; parameter[2].Text = "@jgbm"; parameter[2].Value = InstanceForm.BCurrentDept.Jgbm; parameter[3].Text = "@SS_FLAG"; parameter[3].Value = checkBox1.Checked ? 1 : 0; dt = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_ZY_TJ_YSYPSRBL", parameter, 100); } PubStaticFun.SetDataGridIncreaseRowNumber(dt, "序号"); dataGridView1.DataSource = dt; }