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);
}
