/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WebApi_Model.T_UserRecharge model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_UserRecharge(");
strSql.Append("UID,RechargeID,RechargeDate)");
strSql.Append(" values (");
strSql.Append("@UID,@RechargeID,@RechargeDate)");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.Int, 4),
new SqlParameter("@RechargeID", SqlDbType.Int, 4),
new SqlParameter("@RechargeDate", SqlDbType.DateTime)
};
parameters[0].Value = model.UID;
parameters[1].Value = model.RechargeID;
parameters[2].Value = model.RechargeDate;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_UserRecharge GetModel(int UID, int RechargeID, DateTime RechargeDate)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UID,RechargeID,RechargeDate from T_UserRecharge ");
strSql.Append(" where UID=@UID and RechargeID=@RechargeID and RechargeDate=@RechargeDate ");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.Int, 4),
new SqlParameter("@RechargeID", SqlDbType.Int, 4),
new SqlParameter("@RechargeDate", SqlDbType.DateTime)
};
parameters[0].Value = UID;
parameters[1].Value = RechargeID;
parameters[2].Value = RechargeDate;
WebApi_Model.T_UserRecharge model = new WebApi_Model.T_UserRecharge();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebApi_Model.T_UserRecharge model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_UserRecharge set ");
strSql.Append("UID=@UID,");
strSql.Append("RechargeID=@RechargeID,");
strSql.Append("RechargeDate=@RechargeDate");
strSql.Append(" where UID=@UID and RechargeID=@RechargeID and RechargeDate=@RechargeDate ");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.Int, 4),
new SqlParameter("@RechargeID", SqlDbType.Int, 4),
new SqlParameter("@RechargeDate", SqlDbType.DateTime)
};
parameters[0].Value = model.UID;
parameters[1].Value = model.RechargeID;
parameters[2].Value = model.RechargeDate;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_UserRecharge DataRowToModel(DataRow row)
{
WebApi_Model.T_UserRecharge model = new WebApi_Model.T_UserRecharge();
if (row != null)
{
if (row["UID"] != null && row["UID"].ToString() != "")
{
model.UID = int.Parse(row["UID"].ToString());
}
if (row["RechargeID"] != null && row["RechargeID"].ToString() != "")
{
model.RechargeID = int.Parse(row["RechargeID"].ToString());
}
if (row["RechargeDate"] != null && row["RechargeDate"].ToString() != "")
{
model.RechargeDate = DateTime.Parse(row["RechargeDate"].ToString());
}
}
return(model);
}
