/// <summary> /// 查询数据 /// </summary> private void SelectData() { try { string where_date = TjMeans.GetDateWhere("a.sfrq", this.list_datewhere); int _isview = 0; if (this.isview) { _isview = 1; } ParameterEx[] parameters = new ParameterEx[8]; parameters[0].Text = "@type"; parameters[0].Value = rdJg.Checked == true ? 0 : 1; int _jsfs = 0; if (rbYb.Checked) { _jsfs = 1; } else if (rbZf.Checked) { _jsfs = 2; } else { _jsfs = 0; } parameters[1].Text = "@jsfs"; parameters[1].Value = _jsfs; parameters[2].Text = "@jgbm"; parameters[2].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0")); parameters[3].Text = "@bks"; parameters[3].Value = checkBox2.Checked == true ? 1 : 0; parameters[4].Text = "@dept_id"; parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbdept.SelectedValue, "0")); parameters[5].Text = "@isview"; parameters[5].Value = _isview; parameters[6].Text = "@datewhere"; parameters[6].Value = where_date; parameters[7].Text = "@sfdeptid"; parameters[7].Value = this.Cmb_SfDept.SelectedValue.ToString().Trim() == "-1" ? "" : this.Cmb_SfDept.SelectedValue.ToString(); DataSet dset = new DataSet(); TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_yssrtjByDate", parameters, dset, "sfmx", 30); Fun.AddRowtNo(dset.Tables[0]); this.dataGridView1.DataSource = dset.Tables[0]; } catch (Exception ea) { MessageBox.Show("出现错误!原因:" + ea.Message, "异常"); } }
/// <summary> /// 获取日期条件 add by zp 2013-07-18 /// </summary> /// <returns></returns> //private string GetDateWhere(string columnName) //{ // string whre_date = " and ("; // try // { // DateTimePicker dtp = null; // for (int i = 0; i < this.list_datewhere.Count; i++) // { // if (list_datewhere[i] is DateTimePicker) // { // dtp = (DateTimePicker)list_datewhere[i]; // string name = dtp.Name; // int index = int.Parse(name.Substring(3, 1)); // if (index % 2 > 0) //单数 开始日期 // { // if (i > 1) // { // whre_date += " or (" + columnName + ">=convert(varchar,'" + dtp.Value + "',120)";//a.sfrq // } // else // { // whre_date += " " + columnName + ">=convert(varchar,'" + dtp.Value + "',120)"; // } // } // else // { // if (i > 1) // { // whre_date += " and " + columnName + "<=convert(varchar,'" + dtp.Value + "',120))"; // } // else // { // whre_date += " and " + columnName + "<=convert(varchar,'" + dtp.Value + "',120)"; // } // } // } // } // whre_date += ")"; // } // catch (Exception ea) // { // MessageBox.Show("出现异常!原因:" + ea.Message, "提示"); // } // return whre_date; //} /// <summary> /// 统计事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttj_Click(object sender, EventArgs e) { Cursor = TrasenClasses.GeneralClasses.PubStaticFun.WaitCursor(); string where_ghdate = TjMeans.GetDateWhere("ghsj", this.list_datewhere); string where_qxghdate = TjMeans.GetDateWhere("qxghsj", this.list_datewhere); this.buttj.Enabled = false; this.butprint.Enabled = false; this.butquit.Enabled = false; try { ParameterEx[] parameters = new ParameterEx[7]; parameters[0].Text = "@datewhere_gh"; parameters[0].Value = where_ghdate; parameters[1].Text = "@datewhere_qxgh"; parameters[1].Value = where_qxghdate; parameters[2].Text = "@jgbm"; parameters[2].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0")); parameters[3].Text = "@jzks"; parameters[3].Value = txtks.Text.Trim() == ""?"0":Convertor.IsNull(txtks.Tag, "0"); parameters[4].Text = "@jzys"; parameters[4].Value = txtys.Text.Trim() == "" ? "0" : Convertor.IsNull(txtys.Tag, "0"); parameters[5].Text = "@ghjb"; parameters[5].Value = Convertor.IsNull(cmbghjb.SelectedValue, "0"); parameters[6].Text = "@sortid"; parameters[6].Value = cmbpx.SelectedIndex; DataTable tb; tb = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZSF_TJ_YSJZLTJ_BYDATE", parameters, 30); Fun.AddRowtNo(tb); this.dgvList.DataSource = tb; } catch (System.Exception err) { MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor = Cursors.Default; buttj.Enabled = true; this.butprint.Enabled = true; this.butquit.Enabled = true; } }
/// <summary> /// 获取日期条件 add by zp 2013-07-18 /// </summary> /// <returns></returns> //private string GetDateWhere(string columnName) //{ // string whre_date = " and ("; // try // { // string sql = @"select DATEADD(DD,-1*" + this.cfg13.Config + ",getdate())"; // DateTime _date = Convert.ToDateTime(InstanceForm.BDatabase.GetDataResult(sql)); // DateTimePicker dtp = null; // for (int i = 0; i < this.list_datewhere.Count; i++) // { // if (list_datewhere[i] is DateTimePicker) // { // dtp = (DateTimePicker)list_datewhere[i]; // string name = dtp.Name; // int index = int.Parse(name.Substring(3, 1)); // if (index % 2 > 0) //单数 开始日期 // { // if (i > 1) // { // whre_date += " or (" + columnName + ">=convert(varchar,'" + dtp.Value + "',120)";//a.sfrq // } // else // { // whre_date += " " + columnName + ">=convert(varchar,'" + dtp.Value + "',120)"; // } // } // else // { // if (i > 1) // { // whre_date += " and " + columnName + "<=convert(varchar,'" + dtp.Value + "',120))"; // } // else // { // whre_date += " and " + columnName + "<=convert(varchar,'" + dtp.Value + "',120)"; // } // } // } // } // whre_date += ")"; // } // catch (Exception ea) // { // MessageBox.Show("出现异常!原因:" + ea.Message, "提示"); // } // return whre_date; //} public void btref_Click(object sender, EventArgs e) { try { string execdept = ""; for (int i = 0; i <= TreeDept.Nodes[0].Nodes.Count - 1; i++) { if (TreeDept.Nodes[0].Nodes[i].Checked == true) { execdept = execdept + TreeDept.Nodes[0].Nodes[i].Tag + ","; } } if (execdept != "") { execdept = "(" + execdept.Substring(0, execdept.Length - 1) + ")"; } else { MessageBox.Show("请选择科室", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string tjdxm = ""; for (int i = 0; i <= TreeXm.Nodes[0].Nodes.Count - 1; i++) { if (TreeXm.Nodes[0].Nodes[i].Checked == true) { tjdxm = tjdxm + "'" + TreeXm.Nodes[0].Nodes[i].Tag + "',"; } } if (tjdxm != "") { tjdxm = "(" + tjdxm.Substring(0, tjdxm.Length - 1) + ")"; } //ParameterEx[] parameters = new ParameterEx[8]; //parameters[0].Text = "@execdept"; //parameters[0].Value = execdept; //parameters[1].Text = "@RQ1"; //parameters[1].Value = chksfrq.Checked==true? dtp1.Value.ToString():""; //parameters[2].Text = "@RQ2"; //parameters[2].Value = chksfrq.Checked == true ? dtp2.Value.ToString() : ""; //parameters[3].Text = "@jgbm"; //parameters[3].Value = Convert.ToInt64(cmbjgbm.SelectedValue); //parameters[4].Text = "@qrrq1"; //parameters[4].Value = chkqfrq.Checked == true ? dtpqrrq1.Value.ToString() : ""; //parameters[5].Text = "@qrrq2"; //parameters[5].Value = chkqfrq.Checked == true ? dtpqrrq2.Value.ToString() : ""; //parameters[6].Text = "@tjdxm"; //parameters[6].Value = tjdxm; //parameters[7].Text = "@zxr"; //parameters[7].Value = 0; //DataSet dset = new DataSet(); //TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_kssrtj_mx", parameters, dset, "sfmx", 30); string where_date = ""; if (chksfrq.Checked) { where_date = TjMeans.GetDateWhere("a.sfrq", this.list_datewhere); } else { where_date = TjMeans.GetDateWhere("b.qrsj", this.list_datewhere); } ParameterEx[] parameters = new ParameterEx[6]; //modify by zp 2013-10-23 parameters[0].Text = "@execdept"; parameters[0].Value = execdept; parameters[1].Text = "@isview"; parameters[1].Value = 1; parameters[2].Text = "@datewhere"; parameters[2].Value = where_date; parameters[3].Text = "@jgbm"; parameters[3].Value = Convert.ToInt64(cmbjgbm.SelectedValue); parameters[4].Text = "@tjdxm"; parameters[4].Value = tjdxm; parameters[5].Text = "@zxr"; parameters[5].Value = 0; DataSet dset = new DataSet(); TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_kssrtj_mxByDate", parameters, dset, "sfmx", 30); Fun.AddRowtNo(dset.Tables[0]); Fun.AddRowtNo(dset.Tables[1]); Fun.AddRowtNo(dset.Tables[2]); Fun.AddRowtNo(dset.Tables[3]); decimal je = Convert.ToDecimal(Convertor.IsNull(dset.Tables[0].Compute("sum(金额)", ""), "0")); decimal je1 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[1].Compute("sum(金额)", ""), "0")); decimal je2 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[2].Compute("sum(金额)", ""), "0")); //add by zouchihua 2013-6-25 decimal je3 = Convert.ToDecimal(Convertor.IsNull(dset.Tables[3].Compute("sum(金额)", ""), "0")); DataRow row = dset.Tables[0].NewRow(); row["序号"] = "合计"; row["金额"] = je.ToString(); dset.Tables[0].Rows.Add(row); DataRow row1 = dset.Tables[1].NewRow(); row1["序号"] = "合计"; row1["金额"] = je1.ToString(); dset.Tables[1].Rows.Add(row1); DataRow row2 = dset.Tables[2].NewRow(); row2["序号"] = "合计"; row2["金额"] = je2.ToString(); dset.Tables[2].Rows.Add(row2); DataRow row3 = dset.Tables[3].NewRow(); row3["序号"] = "合计"; row3["金额"] = je3.ToString(); dset.Tables[3].Rows.Add(row3); dataGridView1.DataSource = dset.Tables[0]; dataGridView2.DataSource = dset.Tables[2]; dataGridView3.DataSource = dset.Tables[1]; //add by zouchihua 2013-6-25 dataGridView4.DataSource = dset.Tables[3]; } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 统计数据 /// </summary> private void SelectData() { try { string where_date = ""; if (chksfrq.Checked) { where_date = TjMeans.GetDateWhere("a.sfrq", this.list_datewhere); } else { where_date = TjMeans.GetDateWhere("qrsj", this.list_datewhere); } int _isview = 0; if (this.isview) { _isview = 1; } ParameterEx[] parameters = new ParameterEx[7]; parameters[0].Text = "@isview"; parameters[0].Value = _isview;//chksfrq.Checked == true ? dtp1.Value.ToString() : ""; parameters[1].Text = "@datewhere"; parameters[1].Value = where_date;//chksfrq.Checked == true ? dtp2.Value.ToString() : ""; parameters[2].Text = "@type"; parameters[2].Value = rdJg.Checked == true ? 0 : 1; int _jsfs = 0; if (rbYb.Checked) { _jsfs = 1; } else if (rbZf.Checked) { _jsfs = 2; } else { _jsfs = 0; } parameters[3].Text = "@jsfs"; parameters[3].Value = _jsfs; parameters[4].Text = "@jgbm"; parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbjgbm.SelectedValue, "0")); parameters[5].Text = "@include_kdks"; parameters[5].Value = checkBox2.Checked == true ? 0 : 1; //parameters[6].Text = "@qsfrq1"; //parameters[6].Value = chkqfrq.Checked == true ? where_date : "";//chkqfrq.Checked == true ? dtpqrrq1.Value.ToString() : ""; //parameters[7].Text = "@qsfrq2"; //parameters[7].Value = chkqfrq.Checked == true ? dtpqrrq2.Value.ToString() : ""; parameters[6].Text = "@zxksdm"; parameters[6].Value = Convertor.IsNull(txtzxks.Tag, "0").ToString(); DataSet dset = new DataSet(); TrasenFrame.Forms.FrmMdiMain.Database.AdapterFillDataSet("SP_MZSF_TJ_SK_ZxkssrtjByDate", parameters, dset, "sfmx", 30); Fun.AddRowtNo(dset.Tables[0]); this.dataGridView1.DataSource = dset.Tables[0]; } catch (Exception ea) { MessageBox.Show("出现异常!原因:" + ea.Message, "提示"); } }