/// <summary>
/// 编辑项目信息
/// </summary>
/// <param name="name">项目名称</param>
/// <param name="money">目标金额</param>
/// <param name="count">支持人数</param>
/// <param name="pros">人气</param>
/// <param name="classid">类型</param>
/// <param name="projectid">项目ID</param>
/// <returns></returns>
public static bool EditProject(string name, decimal money, int count, int pros, int classid, int projectid)
{
string sql = $"update project set ProjectName = '{name}',TargetMoney={money},SupportCount={count}," +
$"Progress={pros},ClassID={classid} where ProjectID={projectid}";
return(DBH.ExecuteNonQuery(sql));
}
/// <summary>
/// 删除项目信息
/// </summary>
/// <param name="id">项目ID</param>
/// <returns></returns>
public static bool DelProject(int id)
{
string sql = $"delete from project where projectID = {id}";
return(DBH.ExecuteNonQuery(sql));
}
/// <summary>
/// 添加项目信息
/// </summary>
/// <param name="name">项目名称</param>
/// <param name="money">目标金额</param>
/// <param name="count">支持人数</param>
/// <param name="pros">人气</param>
/// <param name="classid">类型</param>
/// <returns></returns>
public static bool AddProject(string name, decimal money, int count, int pros, int classid)
{
string sql = $"insert into project values('{name},'{money},{count},{pros},{classid})";
return(DBH.ExecuteNonQuery(sql));
}
