/// <summary> /// 获取消费明细汇总信息 /// </summary> /// <param name="companyId">公司编号</param> /// <returns></returns> public virtual EyouSoft.Model.SMSStructure.AccountExpenseCollectInfo GetAccountExpenseCollectInfo(string companyId) { EyouSoft.Model.SMSStructure.AccountExpenseCollectInfo accountExpenseCollectInfo = new EyouSoft.Model.SMSStructure.AccountExpenseCollectInfo(); DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_SELECT_GETACCOUNTEXPENSECOLLECTINFO); base.SMSStore.AddInParameter(cmd, "COMPANYID", DbType.AnsiStringFixedLength, companyId); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SMSStore)) { if (rdr.Read()) { if (!rdr.IsDBNull(rdr.GetOrdinal("SentMessageCount"))) { accountExpenseCollectInfo.SentMessageCount = rdr.GetInt32(rdr.GetOrdinal("SentMessageCount")); } if (!rdr.IsDBNull(rdr.GetOrdinal("ExpenseAmount"))) { accountExpenseCollectInfo.ExpenseAmount = rdr.GetDecimal(rdr.GetOrdinal("ExpenseAmount")); } } } return(accountExpenseCollectInfo); }
/// <summary> /// 消费明细 /// </summary> protected void GetExpenseDetailList() { int intRecordCount = 0; IList <EyouSoft.Model.SMSStructure.SendTotalInfo> ExpenseDetailList = EyouSoft.BLL.SMSStructure.Account.CreateInstance().GetExpenseDetails(PageSize, PageIndex, ref intRecordCount, Request.QueryString["CompanyId"]); if (intRecordCount > 0) { this.GetExpenseDetail_ExporPageInfoSelect.intPageSize = PageSize; this.GetExpenseDetail_ExporPageInfoSelect.intRecordCount = intRecordCount; this.GetExpenseDetail_ExporPageInfoSelect.CurrencyPage = PageIndex; this.GetExpenseDetail_ExporPageInfoSelect.HrefType = Adpost.Common.ExporPage.HrefTypeEnum.JsHref; this.GetExpenseDetail_ExporPageInfoSelect.AttributesEventAdd("onclick", "AccountInfo.ExpenseDetailLoadData(this);", 1); //this.GetExpenseDetail_ExporPageInfoSelect.AttributesEventAdd("onchange", "AccountInfo.ExpenseDetailLoadData(this);", 0); this.GetExpenseDetail_repExpenseDetail.DataSource = ExpenseDetailList; this.GetExpenseDetail_repExpenseDetail.DataBind(); if (intRecordCount > PageSize) { this.GetExpenseDetail_ExporPageInfoSelect.Visible = true; } else { this.GetExpenseDetail_ExporPageInfoSelect.Visible = false; } //汇总 this.GetExpenseDetail_tbSumCountAndMoney.Visible = true; EyouSoft.Model.SMSStructure.AccountExpenseCollectInfo model = EyouSoft.BLL.SMSStructure.Account.CreateInstance().GetAccountExpenseCollectInfo(Request.QueryString["CompanyId"]); if (model != null) { this.GetExpenseDetail_labSumSendCount.Text = model.SentMessageCount.ToString(); this.GetExpenseDetail_labSumSendMoney.Text = model.ExpenseAmount.ToString("F2"); } model = null; } else { this.GetExpenseDetail_ExporPageInfoSelect.Visible = false; this.GetExpenseDetail_repExpenseDetail.EmptyText = "<div>暂无消费明细</div>"; } ExpenseDetailList = null; }