/// <summary>
/// 根据开始时间，结束时间查询开门记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
if (this.dateStart.Text == string.Empty)
{
XtraMessageBox.Show("请输入开始时间", "系统提示！");
return;
}
if (this.dateEnd.Text == string.Empty)
{
XtraMessageBox.Show("请输入结束时间", "系统提示！");
return;
}
string dataStart = this.dateStart.Text.Trim();
string dataEnd = this.dateEnd.Text.Trim();
string where = " 时间 >= '" + dataStart + "' and 时间 <= '" + dataEnd + "' ";
if (this.lookDoor.EditValue != null && this.lookDoor.EditValue.ToString() != "全部")
{
where += " and 门编号='" + this.lookDoor.EditValue.ToString() + "'";
}
this.paramwin = BindManager.getSystemParam();
NameObjectList ps = new NameObjectList();
ps["StartDate"] = this.dateStart.EditValue.ToString();
ps["EndDate"] = this.dateEnd.EditValue.ToString();
ParamManager.MergeParam(ps, this.paramwin, false);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
this.ds = this.bindMgr.BuildDataset(this.unitItem, ps);
DataTable dt = this.ds.Tables["刷卡记录"].Clone();
DataTable dtReport = FunShare.GetTable(dt, this.ds.Tables["刷卡记录"].Select(where));
Report.viwReports View = new viwReports();
View.ReportName = "刷卡报表";
View.dt = dt;
View.StartTime = this.dateStart.Text.Trim();
View.EndTime = this.dateEnd.Text.Trim();
View.Activate();
View.Dock = DockStyle.Fill;
this.groReport.Controls.Clear();
this.groReport.Controls.Add(View);
}
/// <summary>
/// 根据开始时间，结束时间查询开门记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
if( this.dateStart.Text ==string.Empty )
{
XtraMessageBox.Show("请输入开始时间","系统提示！");
return;
}
if (this.dateEnd.Text == string.Empty)
{
XtraMessageBox.Show("请输入结束时间", "系统提示！");
return;
}
string dataStart= this.dateStart.Text.Trim();
string dataEnd = this.dateEnd.Text.Trim();
string where = " 时间 >= '" + dataStart + "' and 时间 <= '" + dataEnd + "' ";
if (this.lookDoor.EditValue != null && this.lookDoor.EditValue.ToString() != "全部")
{
where += " and 门编号='" + this.lookDoor.EditValue.ToString() + "'";
}
this.paramwin = BindManager.getSystemParam();
NameObjectList ps = new NameObjectList();
ps["StartDate"] = this.dateStart.EditValue.ToString();
ps["EndDate"] = this.dateEnd.EditValue.ToString();
ParamManager.MergeParam(ps, this.paramwin, false);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
this.ds = this.bindMgr.BuildDataset(this.unitItem,ps);
DataTable dt = this.ds.Tables["刷卡记录"].Clone();
DataTable dtReport = FunShare.GetTable(dt, this.ds.Tables["刷卡记录"].Select(where));
Report.viwReports View = new viwReports();
View.ReportName = "刷卡报表";
View.dt = dt;
View.StartTime = this.dateStart.Text.Trim();
View.EndTime = this.dateEnd.Text.Trim();
View.Activate();
View.Dock = DockStyle.Fill;
this.groReport.Controls.Clear();
this.groReport.Controls.Add(View);
}