protected void btnPointRankExcel_Click(object sender, EventArgs e) { SysUserWork bllsysuserwork = new SysUserWork(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += "and SysUserWork.userID = SysUser.userid and SysUser.UserShopID = SysShop.ShopID "; strSql = PubFunction.GetShopAuthority(this._UserShopID, "UserShopID", strSql); DataTable dtPoint = bllsysuserwork.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.PointUserWorkExcel(dtPoint, this._UserName); }