/// <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, "提示");
}
}
