private void Show_Condition()
{
Frm_financeDaySearch frm_1 = new Frm_financeDaySearch();
frm_1.swapdata["BusinessObject"] = this;
if (frm_1.ShowDialog() == DialogResult.OK)
{
frm_1.Dispose();
string s_begin = string.Empty;
string s_end = string.Empty;
string s_fa003 = string.Empty;
if (this.swapdata["dbegin"] == null)
{
s_begin = "1900/01/01";
}
else
{
s_begin = Convert.ToDateTime(this.swapdata["dbegin"]).ToString("yyyy/MM/dd");
}
if (this.swapdata["dend"] == null)
{
s_end = "9999/12/31";
}
else
{
s_end = Convert.ToDateTime(this.swapdata["dend"]).ToString("yyyy/MM/dd");
}
if (this.swapdata["FA003"] == null || string.IsNullOrEmpty(this.swapdata["FA003"].ToString()))
{
s_fa003 = "%";
}
else
{
s_fa003 = this.swapdata["FA003"].ToString() + "%";
}
op_begin.Value = s_begin;
op_end.Value = s_end;
op_fa003.Value = s_fa003;
gridView1.BeginUpdate();
dt_finance.Rows.Clear();
finAdapter.Fill(dt_finance);
gridCol_Fa004.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridCol_Fa004.SummaryItem.DisplayFormat = "合计 = {0:N2}";
gridColumn5.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridColumn5.SummaryItem.DisplayFormat = "共计 = {0:N0}笔";
gridView1.EndUpdate();
}
}
/// <summary>
/// 显示查询条件
/// </summary>
private void Show_Condition()
{
Frm_financeDaySearch frm_1 = new Frm_financeDaySearch();
frm_1.swapdata["BusinessObject"] = this;
if (frm_1.ShowDialog() == DialogResult.OK)
{
string s_begin = string.Empty;
string s_end = string.Empty;
string s_fa003 = string.Empty;
string s_fa100 = string.Empty;
if (frm_1.swapdata["dbegin"] == null)
{
s_begin = "1900/01/01";
}
else
{
s_begin = Convert.ToDateTime(frm_1.swapdata["dbegin"]).ToString("yyyy/MM/dd");
}
if (frm_1.swapdata["dend"] == null)
{
s_end = "9999/12/31";
}
else
{
s_end = Convert.ToDateTime(frm_1.swapdata["dend"]).ToString("yyyy/MM/dd");
}
if (frm_1.swapdata["FA003"] == null || string.IsNullOrEmpty(frm_1.swapdata["FA003"].ToString()))
{
s_fa003 = "%";
}
else
{
s_fa003 = frm_1.swapdata["FA003"].ToString() + "%";
}
if (frm_1.swapdata["FA100"] == null)
{
s_fa100 = "%";
}
else
{
s_fa100 = frm_1.swapdata["FA100"].ToString();
}
op_begin.Value = s_begin;
op_end.Value = s_end;
op_fa003.Value = s_fa003;
op_fa100.Value = s_fa100;
op_begin_2.Value = s_begin;
op_end_2.Value = s_end;
op_fa003_2.Value = s_fa003;
op_fa100_2.Value = s_fa100;
this.Cursor = Cursors.WaitCursor;
//////1.按收费笔数检索
gridView1.BeginUpdate();
dt_finance.Rows.Clear();
finAdapter.Fill(dt_finance);
gridCol_Fa004.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridCol_Fa004.SummaryItem.DisplayFormat = "合计 = {0:N2}";
gridColumn5.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridColumn5.SummaryItem.DisplayFormat = "共计 = {0:N0}笔";
gridView1.EndUpdate();
//////2. 按发票检索
gridView3.BeginUpdate();
dt_invoice.Rows.Clear();
invAdapter.Fill(dt_invoice);
gridColumn_fee.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridColumn_fee.SummaryItem.DisplayFormat = "合计 = {0:N2}";
gridColumn_ph.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridColumn_ph.SummaryItem.DisplayFormat = "共计 = {0:N0}张发票";
gridView3.EndUpdate();
this.Cursor = Cursors.Arrow;
}
frm_1.Dispose();
}
