protected void btnOut_Click(object sender, EventArgs e) { Chain.BLL.Goods bllGoods = new Chain.BLL.Goods(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and Goods.GoodsClassID = GoodsClass.ClassID and Goods.GoodsID = GoodsNumber.GoodsID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql); DataTable dtGoods = bllGoods.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.GoodsListExcel(dtGoods, this._UserName); }