/// <summary>
/// 客户充值（未审核状态）
/// </summary>
/// <param name="model">充值明细实体</param>
/// <returns>返回1成功，其他失败</returns>
public int RechargeByCostomer(MSmsBankCharge model)
{
if (model == null || string.IsNullOrEmpty(model.AccountId) || string.IsNullOrEmpty(model.AppKey) ||
model.ChargeAmount <= 0)
{
return(0);
}
model.Status = ChargeStatus.未审核;
model.RealAmount = 0;
model.IssueTime = DateTime.Now;
return(_dal.Recharge(model));
}
/// <summary>
/// 充值
/// </summary>
/// <param name="model">充值明细实体</param>
/// <returns>返回1成功，其他失败</returns>
public int Recharge(MSmsBankCharge model)
{
if (string.IsNullOrEmpty(model.AccountId) || model.ChargeAmount <= 0)
{
return(0);
}
model.ChargeId = Guid.NewGuid().ToString();
var strSql = new StringBuilder(SqlSmsBankChargeAdd);
DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());
_db.AddInParameter(dc, "ChargeId", DbType.AnsiStringFixedLength, model.ChargeId);
_db.AddInParameter(dc, "AccountId", DbType.AnsiStringFixedLength, model.AccountId);
_db.AddInParameter(dc, "ChargeAmount", DbType.Decimal, model.ChargeAmount);
_db.AddInParameter(dc, "Status", DbType.Byte, (int)model.Status);
_db.AddInParameter(dc, "RealAmount", DbType.Decimal, model.RealAmount);
_db.AddInParameter(dc, "ChargeComName", DbType.String, model.ChargeComName);
_db.AddInParameter(dc, "ChargeName", DbType.String, model.ChargeName);
_db.AddInParameter(dc, "ChargeTelephone", DbType.String, model.ChargeTelephone);
_db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime);
return(DbHelper.ExecuteSql(dc, _db) > 0 ? 1 : 0);
}
/// <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);
}
