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