/// <summary>
/// 根据查询实体生成SqlWhere子句
/// </summary>
/// <param name="queryModel">查询实体</param>
/// <returns>SqlWhere子句</returns>
private string GetSqlWhere(MQuerySmsBankCharge queryModel)
{
if (queryModel == null)
{
return(string.Empty);
}
var strWhere = new StringBuilder(" 1 = 1 ");
if (!string.IsNullOrEmpty(queryModel.AccountId))
{
strWhere.AppendFormat(" and AccountId = '{0}' ", queryModel.AccountId);
}
if (!string.IsNullOrEmpty(queryModel.AppKey))
{
strWhere.AppendFormat(" and AppKey = '{0}' ", queryModel.AppKey);
}
if (!string.IsNullOrEmpty(queryModel.AppSecret))
{
strWhere.AppendFormat(" and AppSecret = '{0}' ", queryModel.AppSecret);
}
if (queryModel.Status.HasValue)
{
strWhere.AppendFormat(" and [Status] = {0} ", (int)queryModel.Status.Value);
}
if (!string.IsNullOrEmpty(queryModel.ChargeComName))
{
strWhere.AppendFormat(" and ChargeComName like '%{0}%' ", queryModel.ChargeComName);
}
if (!string.IsNullOrEmpty(queryModel.ChargeName))
{
strWhere.AppendFormat(" and ChargeName like '%{0}%' ", queryModel.ChargeName);
}
if (queryModel.StartTime.HasValue)
{
strWhere.AppendFormat(" and IssueTime >= '{0}' ", queryModel.StartTime.Value);
}
if (queryModel.EndTime.HasValue)
{
strWhere.AppendFormat(" and IssueTime <= '{0}' ", queryModel.EndTime.Value);
}
return(strWhere.ToString());
}
/// <summary>
/// 查询充值明细
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回充值明细集合</returns>
public List <MSmsBankCharge> GetSmsBankCharge(int pageSize, int pageIndex, ref int recordCount
, MQuerySmsBankCharge queryModel)
{
List <MSmsBankCharge> list = null;
MSmsBankCharge model;
string fields = "*";
string tableName = "view_SmsBankChargeAccount";
string orderByString = " [IssueTime] desc ";
string identityColumnName = " ChargeId ";
using (IDataReader dr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName
, identityColumnName, fields, GetSqlWhere(queryModel), orderByString))
{
list = new List <MSmsBankCharge>();
while (dr.Read())
{
model = new MSmsBankCharge();
if (!dr.IsDBNull(dr.GetOrdinal("ChargeId")))
{
model.ChargeId = dr.GetString(dr.GetOrdinal("ChargeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AccountId")))
{
model.AccountId = dr.GetString(dr.GetOrdinal("AccountId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ChargeAmount")))
{
model.ChargeAmount = dr.GetDecimal(dr.GetOrdinal("ChargeAmount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Status")))
{
model.Status = (ChargeStatus)dr.GetByte(dr.GetOrdinal("Status"));
}
if (!dr.IsDBNull(dr.GetOrdinal("RealAmount")))
{
model.RealAmount = dr.GetDecimal(dr.GetOrdinal("RealAmount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ChargeComName")))
{
model.ChargeComName = dr.GetString(dr.GetOrdinal("ChargeComName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ChargeName")))
{
model.ChargeName = dr.GetString(dr.GetOrdinal("ChargeName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ChargeTelephone")))
{
model.ChargeTelephone = dr.GetString(dr.GetOrdinal("ChargeTelephone"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AppKey")))
{
model.AppKey = dr.GetString(dr.GetOrdinal("AppKey"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AppSecret")))
{
model.AppSecret = dr.GetString(dr.GetOrdinal("AppSecret"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Amount")))
{
model.Amount = dr.GetDecimal(dr.GetOrdinal("Amount"));
}
model.SysType = (SystemType)dr.GetByte(dr.GetOrdinal("SysType"));
model.ShenHeBeiZhu = dr["ShenHeBeiZhu"].ToString();
model.ShenHeRen = dr["ShenHeRen"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("ShenHeShiJian")))
{
model.ShenHeShiJian = dr.GetDateTime(dr.GetOrdinal("ShenHeShiJian"));
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 查询充值明细
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="queryModel">查询实体</param>
/// <returns>返回充值明细集合</returns>
public List <MSmsBankCharge> GetSmsBankCharge(int pageSize, int pageIndex, ref int recordCount
, MQuerySmsBankCharge queryModel)
{
return(_dal.GetSmsBankCharge(pageSize, pageIndex, ref recordCount, queryModel));
}
