/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebApi_Model.T_RechargeType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_RechargeType(");
strSql.Append("RechargeName,AddDays,ICO,AddPiaoZi,RechargePrice)");
strSql.Append(" values (");
strSql.Append("@RechargeName,@AddDays,@ICO,@AddPiaoZi,@RechargePrice)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RechargeName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddDays", SqlDbType.Int, 4),
new SqlParameter("@ICO", SqlDbType.NVarChar, 50),
new SqlParameter("@AddPiaoZi", SqlDbType.Int, 4),
new SqlParameter("@RechargePrice", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.RechargeName;
parameters[1].Value = model.AddDays;
parameters[2].Value = model.ICO;
parameters[3].Value = model.AddPiaoZi;
parameters[4].Value = model.RechargePrice;
object obj = WebApi_DBUtility.DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_RechargeType DataRowToModel(DataRow row)
{
WebApi_Model.T_RechargeType model = new WebApi_Model.T_RechargeType();
if (row != null)
{
if (row["RechargeID"] != null && row["RechargeID"].ToString() != "")
{
model.RechargeID = int.Parse(row["RechargeID"].ToString());
}
if (row["RechargeName"] != null)
{
model.RechargeName = row["RechargeName"].ToString();
}
if (row["AddDays"] != null && row["AddDays"].ToString() != "")
{
model.AddDays = int.Parse(row["AddDays"].ToString());
}
if (row["ICO"] != null)
{
model.ICO = row["ICO"].ToString();
}
if (row["AddPiaoZi"] != null && row["AddPiaoZi"].ToString() != "")
{
model.AddPiaoZi = int.Parse(row["AddPiaoZi"].ToString());
}
if (row["RechargePrice"] != null && row["RechargePrice"].ToString() != "")
{
model.RechargePrice = decimal.Parse(row["RechargePrice"].ToString());
}
}
return(model);
}
public WebApi_Model.T_User UserRecharge(WebApi_Model.T_User user, WebApi_Model.T_RechargeType rechargetype)
{
DateTime OverDueDate = new DateTime();
if (user.VipOverDueDate == null || user.VipOverDueDate < DateTime.Now)
{
OverDueDate = DateTime.Now.AddDays((int)rechargetype.AddDays);
user.VipOverDueDate = OverDueDate;
user.PiaoZi += rechargetype.AddPiaoZi;
}
else
{
OverDueDate = (DateTime)user.VipOverDueDate;
user.VipOverDueDate = OverDueDate.AddDays((int)rechargetype.AddDays);
user.PiaoZi += rechargetype.AddPiaoZi;
}
#region ==== Add Recharge ====
WebApi_Model.T_UserRecharge model = new WebApi_Model.T_UserRecharge();
model.UID = user.UID;
model.RechargeID = rechargetype.RechargeID;
model.RechargeDate = DateTime.Now;
this.Add(model);
#endregion
WebApi_DAL.T_User dal = new T_User();
dal.Update(user);
return(user);
}
public IHttpActionResult GetRechageTypeByID(int RechargeID)
{
WebApi_Model.T_RechargeType T_RechargeType = bll.GetModel(RechargeID);
if (T_RechargeType == null)
{
return(Ok(ReturnJsonResult.GetJsonResult(-1, "Error", JsonConvert.SerializeObject(T_RechargeType))));
}
return(Ok(ReturnJsonResult.GetJsonResult(1, "OK", JsonConvert.SerializeObject(T_RechargeType))));
}
public IHttpActionResult Recharge()
{
string UID = requestHelper.GetRequsetForm("UID", "");
string RechargeID = requestHelper.GetRequsetForm("RechargeID", "");
WebApi_Model.T_RechargeType RechargeType = bllRechargeType.GetModel(int.Parse(RechargeID));
WebApi_Model.T_User User = bllUser.GetModel(int.Parse(UID));
if (RechargeType == null || User == null)
{
return(Ok(ReturnJsonResult.GetJsonResult(-1, "Fail", "")));
}
else
{
User = bllUserRecharge.UserRecharge(User, RechargeType);
}
return(Ok(ReturnJsonResult.GetJsonResult(1, "OK", JsonConvert.SerializeObject(User))));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebApi_Model.T_RechargeType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_RechargeType set ");
strSql.Append("RechargeName=@RechargeName,");
strSql.Append("AddDays=@AddDays,");
strSql.Append("ICO=@ICO,");
strSql.Append("AddPiaoZi=@AddPiaoZi,");
strSql.Append("RechargePrice=@RechargePrice");
strSql.Append(" where RechargeID=@RechargeID");
SqlParameter[] parameters =
{
new SqlParameter("@RechargeName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddDays", SqlDbType.Int, 4),
new SqlParameter("@ICO", SqlDbType.NVarChar, 50),
new SqlParameter("@AddPiaoZi", SqlDbType.Int, 4),
new SqlParameter("@RechargePrice", SqlDbType.Decimal, 9),
new SqlParameter("@RechargeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RechargeName;
parameters[1].Value = model.AddDays;
parameters[2].Value = model.ICO;
parameters[3].Value = model.AddPiaoZi;
parameters[4].Value = model.RechargePrice;
parameters[5].Value = model.RechargeID;
int rows = WebApi_DBUtility.DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_RechargeType GetModel(int RechargeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RechargeID,RechargeName,AddDays,ICO,AddPiaoZi,RechargePrice from T_RechargeType ");
strSql.Append(" where RechargeID=@RechargeID");
SqlParameter[] parameters =
{
new SqlParameter("@RechargeID", SqlDbType.Int, 4)
};
parameters[0].Value = RechargeID;
WebApi_Model.T_RechargeType model = new WebApi_Model.T_RechargeType();
DataSet ds = WebApi_DBUtility.DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
