public fZRZ_Order_Kind(CDBAgent dbAgent)
{
InitializeComponent();
this.tbSql.Clear();
this.tbSql.Text = "select * from creditorderrec";
sql = "select custname,(orderamt/10000) as orderamt,(allocateamt/10000) as allocateamt,market from creditorderrec where busikind='0' and orderstatus in ('2','3','A') order by custname ";
DisplaySet();
agent = dbAgent;
agent.ConnectOpen();
}
public fZRZ_Renew(CDBAgent dbAgent)
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
try
{
report.DBAgent = dbAgent;
report.DBSQL="select * from creditrenew ";
report.ReportPath = @"Reports\rpt_ZRZ_Renew.rdlc";
report.DataName="ZRZ_Renew_DataSet";
report.Show();
}
catch (Exception ex)
{
DialogResult eMsg = MessageBox.Show(ex.ToString(), "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public fZRZ_Final(CDBAgent dbAgent)
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
try
{
dbAgent.ConnectOpen();
string sql = "SELECT custname,enddate,amt from contractout where busikind='0' and status='2'";
ds = dbAgent.DataSetQuery(sql);
dt = ds.Tables[0];
this.rvReport.LocalReport.ReportPath = @"Reports\rpt_ZRZ_Final.rdlc";
this.rvReport.LocalReport.DataSources.Clear();
this.rvReport.LocalReport.DataSources.Add(new ReportDataSource("ZRZ_Final_DataSet", dt));
this.rvReport.RefreshReport();
}
catch (Exception ex)
{
DialogResult eMsg = MessageBox.Show(ex.ToString(), "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public fZRZ_Order_Corp(CDBAgent dbAgent)
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
DisplaySet();
try
{
dbAgent.ConnectOpen();
string sql = "select custname,(orderamt/10000) as orderamt,(allocateamt/10000) as allocateamt,market from creditorderrec where busikind='0' and orderstatus in ('0','2','3','A') order by custname ";
ds = dbAgent.DataSetQuery(sql);
dt = ds.Tables[0];
this.reportViewer1.LocalReport.ReportPath = @"Reports\rpt_ZRZ_Order.rdlc";
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("ZRZ_Order_DataSet", dt));
this.reportViewer1.RefreshReport();
}
catch (Exception ex)
{
DialogResult eMsg = MessageBox.Show(ex.ToString(), "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
