private void BindDrawMoney() { MemTransferLog bllMemTransferLog = new MemTransferLog(); string strSql = this.QueryCondition(); DataTable dtMemTransferLog = bllMemTransferLog.GetMoneyCount(strSql).Tables[0]; this.lblTotalMoney.Text = decimal.Parse(dtMemTransferLog.Rows[0]["TransferMoney"].ToString()).ToString("0.00"); }
protected void btnMemTransferMoneyExcel_Click(object sender, EventArgs e) { MemTransferLog bllMemTransferLog = new MemTransferLog(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition(); strSql += " and MemTransferLog.UserID = SysUser.UserID"; DataTable db = bllMemTransferLog.GetListSP(1000000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.MemTransferMoney(db, this._UserName); }
private void Get_ParameterList(string strSql) { MemTransferLog bllMemTransferLog = new MemTransferLog(); int Counts = this.NetPagerParameter.RecordCount; strSql += " and MemTransferLog.UserID = SysUser.UserID"; DataTable db = bllMemTransferLog.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.gvRptMemTransferMoney.DataSource = db; this.gvRptMemTransferMoney.DataBind(); PageBase.BindSerialRepeater(this.gvRptMemTransferMoney, this.NetPagerParameter.PageSize * (this.NetPagerParameter.CurrentPageIndex - 1)); }