protected void btnOut_Click(object sender, EventArgs e)
{
string strSql = this.QueryCondition();
GoodsNumber bllGoodsNumber = new GoodsNumber();
int Counts = this.NetPagerParameter.RecordCount;
strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql);
DataTable db = bllGoodsNumber.GetListSP(100000, 1, out Counts, new string[]
{
strSql
}).Tables[0];
DataExcelInfo.GoodsStockTotalExcel(db, this._UserName);
}
private void Get_ParameterList(string strSql)
{
GoodsNumber bllGoodsNumber = new GoodsNumber();
int Counts = this.NetPagerParameter.RecordCount;
strSql = PubFunction.GetShopAuthority(this._UserShopID, "ShopID", strSql);
DataTable db = bllGoodsNumber.GetListSP(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
strSql
}).Tables[0];
this.NetPagerParameter.RecordCount = Counts;
this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[]
{
this.NetPagerParameter.CurrentPageIndex,
this.NetPagerParameter.PageCount,
this.NetPagerParameter.RecordCount,
this.NetPagerParameter.PageSize
});
this.gvPointRankList.DataSource = db;
this.gvPointRankList.DataBind();
}
private void Get_ParameterList(string strSql)
{
GoodsNumber bllGoodsNumber = new GoodsNumber();
int Counts = this.NetPagerParameter.RecordCount;
strSql += string.Format("and GoodsType=0 and ShopID = '{0}'", this._UserShopID);
DataTable db = this.bllGoods.GetGoodsList(this.NetPagerParameter.PageSize, this.NetPagerParameter.CurrentPageIndex, out Counts, new string[]
{
strSql
}).Tables[0];
this.NetPagerParameter.RecordCount = Counts;
this.NetPagerParameter.CustomInfoHTML = string.Format("<div class=\"results\"><span>当前第{0}/{1}页 共{2}条记录 每页{3}条</span></div>", new object[]
{
this.NetPagerParameter.CurrentPageIndex,
this.NetPagerParameter.PageCount,
this.NetPagerParameter.RecordCount,
this.NetPagerParameter.PageSize
});
this.rptStockList.DataSource = db;
this.rptStockList.DataBind();
}
