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;
}