private void GetData_Total()
{
int count = 10;
if (!Int32.TryParse(comboBox1.Text, out count))
{
count = 10;
comboBox1.Text = "10";
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "@rq1";
parameters[0].Value = dtpBjksj.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtpEjksj.Value.ToString();
parameters[2].Text = "@sourceType";
parameters[2].Value = this.cmbSource.SelectedIndex;
parameters[3].Text = "@Num";
parameters[3].Value = count;
parameters[4].Text = "@docName";
parameters[4].Value = textBox1.Text.Replace("'", "''");
this._param = new ClsParams();
this._param.rq1 = DateTime.Parse(dtpBjksj.Value.ToString());
this._param.rq2 = DateTime.Parse(dtpEjksj.Value.ToString());
this._param.sourceType = this.cmbSource.SelectedIndex;
DataSet dset = new DataSet();
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("sp_MZ_QueryBussinessOfdoc", parameters, dset, "sfmx", 60);
Fun.AddRowtNo(dset.Tables[0]);
this.dataGridView1.DataSource = dset.Tables[0];
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || dset.Tables[0].Columns[i].ColumnName.ToLower() == "docid")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
/// <summary>
/// 统计数据
/// </summary>
private void GetData()
{
try
{
ParameterEx[] parameters = new ParameterEx[5];
this._param = new ClsParams();
parameters[0].Text = "@sourceType";
parameters[0].Value = cmbSource.SelectedIndex;
this._param.sourceType = cmbSource.SelectedIndex;
parameters[1].Text = "@ksType";
parameters[1].Value = cmbGroup.SelectedIndex == 2 ? 0:(cmbGroup.SelectedIndex + 1);
this._param.ksType = cmbGroup.SelectedIndex == 2 ? 0 : (cmbGroup.SelectedIndex + 1);
parameters[2].Text = "@rq1";
parameters[2].Value = dtpBjksj.Value.ToString();
this._param.rq1 = dtpBjksj.Value;
parameters[3].Text = "@rq2";
parameters[3].Value = dtpEjksj.Value.ToString();
this._param.rq2 = dtpEjksj.Value;
parameters[4].Text = "@isZXKS";
parameters[4].Value = cmbDepartMentType.SelectedIndex;
this._param.isZXKS = cmbDepartMentType.SelectedIndex;
this._param.itemCode = this._itemCode;
DataSet dset = new DataSet();
if (this._itemCode == 0 || this._itemCode == 3 || this._itemCode == 4)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("report_BusinessIncomeReport_Drugs", parameters, dset, "sfmx", 60);
}
else if (this._itemCode == 1)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBuessinessOfMedicalTechnology", parameters, dset, "sfmx", 30);
}
else if (this._itemCode == 2)
{
TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("ReportBusinessOfMedicalService", parameters, dset, "sfmx", 30);
}
for (int i = 0; i < dset.Tables[0].Columns.Count; i++)
{
if (dset.Tables[0].Columns[i].ColumnName.ToLower() == "ksdm")
{
this._dt = new List <string>();
for (int j = 0; j < dset.Tables[0].Rows.Count; j++)
{
string ksdm = dset.Tables[0].Rows[j][i].ToString();
this._dt.Add(ksdm);
}
}
}
DataTable dt = dset.Tables[0];
#region 全部药品比例
if (this._itemCode == 0)
{
AddColumn(dt, "西药比例", dt.Columns["西药"].Ordinal);
AddColumn(dt, "中草药比例", dt.Columns["中草药"].Ordinal);
AddColumn(dt, "中成药比例", dt.Columns["中成药"].Ordinal);
AddColumn(dt, "自制药比例", dt.Columns["自制药"].Ordinal);
AddColumn(dt, "膏方比例", dt.Columns["膏方"].Ordinal);
AddColumn(dt, "其他比例", dt.Columns["其他"].Ordinal);
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal tmp = 0;
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["西药"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["西药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["西药比例"] = "/";
}
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["中草药"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["中草药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["中草药比例"] = "/";
}
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["中成药"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["中成药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["中成药比例"] = "/";
}
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["自制药"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["自制药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["自制药比例"] = "/";
}
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["膏方"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["膏方比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["膏方比例"] = "/";
}
if (decimal.Parse(dt.Rows[i]["合计"].ToString()) != 0)
{
tmp = decimal.Parse(dt.Rows[i]["其他"].ToString()) / decimal.Parse(dt.Rows[i]["合计"].ToString()) * 100;
dt.Rows[i]["其他比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["其他比例"] = "/";
}
}
}
#endregion
#region 中草药自制药比例
if (this._itemCode == 3)
{
AddColumn(dt, "中草药比例", dt.Columns["中草药"].Ordinal);
AddColumn(dt, "自制药比例", dt.Columns["自制药"].Ordinal);
AddColumn(dt, "膏方比例", dt.Columns["膏方"].Ordinal);
AddColumn(dt, "中/制/膏方比例", dt.Columns["膏方比例"].Ordinal);
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal tmp = 0;
decimal sum = decimal.Parse(dt.Rows[i]["合计"].ToString()) - decimal.Parse(dt.Rows[i]["膏方"].ToString());
if (sum != 0)
{
tmp = decimal.Parse(dt.Rows[i]["中草药"].ToString()) / sum * 100;
dt.Rows[i]["中草药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["中草药比例"] = "/";
}
if (sum != 0)
{
tmp = decimal.Parse(dt.Rows[i]["自制药"].ToString()) / sum * 100;
dt.Rows[i]["自制药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["自制药比例"] = "/";
}
if (sum != 0)
{
tmp = decimal.Parse(dt.Rows[i]["膏方"].ToString()) / sum * 100;
dt.Rows[i]["膏方比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["膏方比例"] = "/";
}
if (sum != 0)
{
tmp = (decimal.Parse(dt.Rows[i]["膏方"].ToString()) + decimal.Parse(dt.Rows[i]["自制药"].ToString()) + decimal.Parse(dt.Rows[i]["中草药"].ToString())) / sum * 100;
dt.Rows[i]["中/制/膏方比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["中/制/膏方比例"] = "/";
}
}
}
#endregion
#region 西药中成药比例
if (this._itemCode == 4)
{
AddColumn(dt, "西药比例", dt.Columns["西药"].Ordinal);
AddColumn(dt, "中成药比例", dt.Columns["中成药"].Ordinal);
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal tmp = 0;
decimal sum = decimal.Parse(dt.Rows[i]["西药"].ToString()) + decimal.Parse(dt.Rows[i]["中成药"].ToString());
if (sum != 0)
{
tmp = decimal.Parse(dt.Rows[i]["西药"].ToString()) / sum * 100;
dt.Rows[i]["西药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["西药比例"] = "/";
}
if (sum != 0)
{
tmp = decimal.Parse(dt.Rows[i]["中成药"].ToString()) / sum * 100;
dt.Rows[i]["中成药比例"] = tmp.ToString("f2");
}
else
{
dt.Rows[i]["中成药比例"] = "/";
}
}
}
#endregion
Fun.AddRowtNo(dt);
this.dataGridView1.Columns.Clear();
this.dataGridView1.DataSource = dt;
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
this.dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
if (this.dataGridView1.Columns[i].Name.ToLower() == "ksdm" || this.dataGridView1.Columns[i].Name.ToLower() == "sort")
{
this.dataGridView1.Columns[i].Visible = false;
}
if (this._itemCode > 2 && this.dataGridView1.Columns[i].Name.Substring(this.dataGridView1.Columns[i].Name.Length - 2) == "人次")
{
this.dataGridView1.Columns[i].Visible = false;
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Frm_BussinessReportOfDoc(ClsParams param)
{
this._param = param;
InitializeComponent();
}
