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()); }