protected void btnRptStaffMoneyExcel_Click(object sender, EventArgs e)
{
int Counts = this.NetPagerParameter.RecordCount;
string strSql = this.QueryCondition();
StringBuilder strDetail = new StringBuilder();
strSql += " and Staff.StaffClassID = StaffClass.ClassID and StaffClass.ClassShopID = SysShop.ShopID";
strSql = PubFunction.GetShopAuthority(this._UserShopID, "ClassShopID", strSql);
StringBuilder strSb = new StringBuilder();
strSb.Append(" 1=1 ");
if (this.txtStaffStartTime.Value != "")
{
strSb.AppendFormat(" and StaffMoney.StaffCreateTime>='{0}'", DateTime.Parse(this.txtStaffStartTime.Value));
strDetail.AppendFormat(" and StaffCreateTime>='{0}'", DateTime.Parse(this.txtStaffStartTime.Value));
}
if (this.txtStaffEndTime.Value != "")
{
strSb.AppendFormat(" and StaffMoney.StaffCreateTime<='{0}'", DateTime.Parse(this.txtStaffEndTime.Value));
strDetail.AppendFormat(" and StaffCreateTime<='{0}'", DateTime.Parse(this.txtStaffEndTime.Value));
}
DataTable dtStaff = this.bllStaff.GetListSP(100000, 1, out Counts, strSb.ToString(), new string[]
{
strSql
}).Tables[0];
DataExcelInfo.StaffMoney(dtStaff, this._UserName, strDetail.ToString());
}