public int Launch(LaunchInfo launchInfo) { string sql = $"INSERT INTO [dbo].[LaunchInfo]([UserId],[TrueName],[PhoneNumber],[BankName],[Branch],[BankCard],[Address],[ProjectId])" + $"VALUES('{launchInfo.UserId}','{launchInfo.TrueName}','{launchInfo.PhoneNumber}','{launchInfo.BankName}','{launchInfo.Branch}','{launchInfo.BankCard}','{launchInfo.Address}','{launchInfo.ProjectId}')"; return(DbHelper.Update(sql)); }
/// <summary> /// 发起项目添加数据方法 /// </summary> /// <param name="project"></param> /// <returns></returns> public int ProjectLaunch(Project project) { string sql = $"INSERT INTO [dbo].[Projects]([ClassifyId],[ProjectName],[Goal],[Deadline],[Content],[CoverImg],[OwnerId],[Address],[Return],[ReturnTime],[Freight],[ReturnMiddle],[ReturnMax])" + $" VALUES('{project.ClassifyId}','{project.ProjectName}','{project.Goal}','{project.Deadline}','{project.Content}','{project.CoverImg}','{project.OwnerId}','{project.Address}','{project.Return}','{project.ReturnTime}','{project.Freight}','{project.ReturnMiddle}','{project.ReturnMax}')"; return(DbHelper.Update(sql)); }
public void OverDate() { string sql = $"select * from Projects"; SqlDataReader dr = DbHelper.GetReader(sql); Project project = null; while (dr.Read()) { project = new Project() { Id = int.Parse(dr["id"].ToString()), Deadline = Convert.ToDateTime(dr["Deadline"]), }; if (project.Deadline < DateTime.Now) { string sql1 = $"UPDATE [dbo].[Projects] set state = 3 where id='{project.Id}'"; DbHelper.Update(sql1); } } ; }
/// <summary> /// 修改用户其他信息 介绍 /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateOtherNoPic(User user) { string sql = $"update users set Description='{user.Description}'where Id='{user.Id}'"; return(DbHelper.Update(sql)); }
/// <summary> /// 修改用户密码 /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdatePassWord(User user) { string sql = $"update users set Pwd='{user.Pwd}' where Id='{user.Id}'"; return(DbHelper.Update(sql)); }
/// <summary> /// 修改用户部分信息 昵称 性别 地址 /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateInfo(User user) { string sql = $"update users set Nickname='{user.Nickname}',Sex='{user.Sex}',Address='{user.Address}'where Id='{user.Id}'"; return(DbHelper.Update(sql)); }
/// <summary> /// 当cookis还没过期 /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateInfoHaveCookies(User user) { string sql = $"update users set Sex='{user.Sex}',Address='{user.Address}' where Id='{user.Id}'"; return(DbHelper.Update(sql)); }
public int InsertData(int UserId, int ProjectId, Decimal Money) { string sql = $"insert into SupportProjects([UserId],[ProjectId],[Money]) values('{UserId}','{ProjectId}','{ Money}')"; return(DbHelper.Update(sql)); }
/// <summary> /// 捐款项目 /// </summary> /// <param name="ProjectId"></param> /// <param name="Money"></param> /// <returns></returns> public int CurrentMoneyAddition(int ProjectId, decimal Money) { string sql = $"update Projects set CurrentMoney= CurrentMoney+'{Money}' where id='{ProjectId}'"; return(DbHelper.Update(sql)); }
/// <summary> /// 取消关注 /// </summary> /// <param name="ProjectId"></param> /// <returns></returns> public int LikeCountSubtraction(int ProjectId) { string sql = $"update Projects set LikeCount= LikeCount-1 where id='{ProjectId}'"; return(DbHelper.Update(sql)); }
public int Delete(int UserId,int ProjectId) { string sql = $"DELETE FROM [dbo].[Likes] where UserId='{UserId}' and ProjectId='{ProjectId}'"; return DbHelper.Update(sql); }
public int Insert(int UserId,int ProjectId) { string sql = $"INSERT INTO [dbo].[Likes] ([UserId] ,[ProjectId])VALUES('{UserId}' ,'{ProjectId}')"; return DbHelper.Update(sql); }