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