protected void IntegralInfo(string UID) { ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Member.Integral bll = new ShowShop.BLL.Member.Integral(); ChangeHope.DataBase.DataByPage dataPage = bll.GetList(" 1=1 and userId=" + UID + ""); //第一步先添加表头 table.AddHeadCol("", "来源内容"); table.AddHeadCol("", "获得积分"); table.AddHeadCol("", "获得时间"); table.AddHeadCol("", "处理者"); table.AddHeadCol("", "备注"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { while (dataPage.DataReader.Read()) { string remark = ChangeHope.Common.StringHelper.SubStringAndAppend(dataPage.DataReader["remark"].ToString(), 100, "..."); table.AddCol(dataPage.DataReader["origin"].ToString()); table.AddCol(dataPage.DataReader["integral"].ToString()); table.AddCol(dataPage.DataReader["gainDate"].ToString()); table.AddCol(dataPage.DataReader["noteName"].ToString()); table.AddCol(remark); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.LitIntegral.Text = view; }