/// <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;
}
