/// <summary>
/// 给项目捐钱
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="projectId">项目id</param>
/// <param name="money">捐钱数额</param>
/// <returns></returns>
public int AddProjectMoney(int userId, int projectId, decimal money)
{
string sql = "update Projects set CurrentMoney=@Money where Id=@ProjectId;" +
"insert into SupportProjects([UserId],[ProjectId],[Money]) values(@UserId,@ProjectId,@Money);";
SqlParameter[] ps = new SqlParameter[]
{
new SqlParameter("@UserId", userId),
new SqlParameter("@ProjectId", projectId),
new SqlParameter("@Money", money),
};
return(DbHelper.ExecuteTransaction(sql, ps));
}