110,571
社区成员
发帖
与我相关
我的任务
分享
//这个是判断成功有会员,进行时间叠加一个月。
bool RenewVip = true;
DateTime paydatetime = UserData.userVipDataTiam;
UserData.userMoney = UserData.userMoney - 9;
//插入充值记录
UserInfoManager.updatePaytime(UserData.userId, 3, Nine_9,Convert.ToString(paydatetime), 2, result);
//到期时间叠加一个月
paydatetime = paydatetime.AddMonths(1);
UserInfoManager.updateVip( UserData.userId, paydatetime);
MessageBox.Show("充值成功", "充值提示", MessageBoxButtons.OK);
//充值叠加会员时间
public static bool updateVip(int userId, DateTime userVipExpTime)
{
string sql = string.Format("Update userVipTime set userVipExpTime='{0}' where userId='{1}'",userVipExpTime,userId);
int rowCount = (int)DBHelper.ExecuteUpdate(sql);
if (rowCount == 1 )
{
return true;
}
else
{
return false;
}
string sql = string.Format("Update userVipTime set userVipExpTime='{0}' where userId='{1}'",userVipExpTime.ToString("yyyy-MM-dd hh:mm:ss"),userId);
[/quote]
还是报那种错误。string sql = string.Format("Update userVipTime set userVipExpTime='{0}' where userId='{1}'",userVipExpTime.ToString("yyyy-MM-dd hh:mm:ss"),userId);