最近捣鼓程序,领导说速度慢。因为数据量较大,网速又不行,加载自然慢,让用户感觉很不爽,因为没给出提示说明 是在加载数据!
在网上查了查资料,看到 DOTNET 2.0 有个新类 BackgroundWorker,感觉蛮符合我遇到的问题。
现在正摸索学习中……
private void RunProgressBar()
{
ProgressForm progressForm = new ProgressForm();//另外的一个窗体,在加载数据 给出提示。
progressForm.Show();
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.WorkerSupportsCancellation = true;
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.ProgressChanged += new ProgressChangedEventHandler(worker_ProgressChanged);
worker.ProgressChanged += new ProgressChangedEventHandler(progressForm.OnProgressChanged);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_ProgressCompleted);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(progressForm.OnProcessCompleted);
worker.RunWorkerAsync();//执行后台操作
}
private void btnPrint_Click(object sender, EventArgs e)
{
this.RunProgressBar();
}
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
PrintReport((BackgroundWorker)sender, e);
}
private void worker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
;//还不是很清楚
}
private void PrintReport(BackgroundWorker worker, DoWorkEventArgs e)
{
e.Result = this.GetReportData(); //从数据库中获取数据
}
private void worker_ProgressCompleted(object sender, RunWorkerCompletedEventArgs e)
{
DataTable dtReport = (DataTable)e.Result;
this.PrintReport(dtReport);//加载数据到水晶报表
}
/// <summary>
/// 打印水晶报表
/// sping 2007-08-03
/// </summary>
/// <param name="dtReport"></param>
private void PrintReport(DataTable dtReport)
{
if (dtReport != null)
{
string strPath = @"Report/PayReport/crWagesScrip.rpt";
string strObj = "txtPrintDate";
string strText = strYear + "年" + strMonth + "月";
FrmCrystalReportViewer frmReport = new FrmCrystalReportViewer();
frmReport.GetCrystalReport(strPath, dtReport, strObj, strText);
frmReport.Show();
}
else
{
MessageBox.Show("出错了!肯能是没有数据,请联系系统管理员!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 打印报表的数据源
/// sping 2007-08-03
/// </summary>
/// <returns></returns>
private DataTable GetReportData()
{
DataTable dt = null;
if (this.txtOrganID.Text != null && this.txtOrganID.Text != "")
{
string strOrganID = this.txtOrganID.Text.ToString();
try
{
//通过数据访问接口使用 存储过程 获取数据
dt = Globals.DataProvider.ExecuteDataSet("WagesScrip_GetReport", strYear, strMonth, strOrganID).Tables[0];//
}
catch (Exception err)
{
MessageBox.Show("出错了,请联系系统管理员!", "错误" + err, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
return dt;
}
在网上查了查资料,看到 DOTNET 2.0 有个新类 BackgroundWorker,感觉蛮符合我遇到的问题。
现在正摸索学习中……
private void RunProgressBar()
{
ProgressForm progressForm = new ProgressForm();//另外的一个窗体,在加载数据 给出提示。
progressForm.Show();
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.WorkerSupportsCancellation = true;
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.ProgressChanged += new ProgressChangedEventHandler(worker_ProgressChanged);
worker.ProgressChanged += new ProgressChangedEventHandler(progressForm.OnProgressChanged);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_ProgressCompleted);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(progressForm.OnProcessCompleted);
worker.RunWorkerAsync();//执行后台操作
}
private void btnPrint_Click(object sender, EventArgs e)
{
this.RunProgressBar();
}
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
PrintReport((BackgroundWorker)sender, e);
}
private void worker_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
;//还不是很清楚
}
private void PrintReport(BackgroundWorker worker, DoWorkEventArgs e)
{
e.Result = this.GetReportData(); //从数据库中获取数据
}
private void worker_ProgressCompleted(object sender, RunWorkerCompletedEventArgs e)
{
DataTable dtReport = (DataTable)e.Result;
this.PrintReport(dtReport);//加载数据到水晶报表
}
/// <summary>
/// 打印水晶报表
/// sping 2007-08-03
/// </summary>
/// <param name="dtReport"></param>
private void PrintReport(DataTable dtReport)
{
if (dtReport != null)
{
string strPath = @"Report/PayReport/crWagesScrip.rpt";
string strObj = "txtPrintDate";
string strText = strYear + "年" + strMonth + "月";
FrmCrystalReportViewer frmReport = new FrmCrystalReportViewer();
frmReport.GetCrystalReport(strPath, dtReport, strObj, strText);
frmReport.Show();
}
else
{
MessageBox.Show("出错了!肯能是没有数据,请联系系统管理员!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 打印报表的数据源
/// sping 2007-08-03
/// </summary>
/// <returns></returns>
private DataTable GetReportData()
{
DataTable dt = null;
if (this.txtOrganID.Text != null && this.txtOrganID.Text != "")
{
string strOrganID = this.txtOrganID.Text.ToString();
try
{
//通过数据访问接口使用 存储过程 获取数据
dt = Globals.DataProvider.ExecuteDataSet("WagesScrip_GetReport", strYear, strMonth, strOrganID).Tables[0];//
}
catch (Exception err)
{
MessageBox.Show("出错了,请联系系统管理员!", "错误" + err, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
return dt;
}