/// <summary>
/// 添加移民项目
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int UpdPro(JiaJiModels.ProjectModel pro)
{
try
{
return(new JiaJiDAL.ProjectDAL().UpdPro(pro));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改移民项目
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int UpdPro(JiaJiModels.ProjectModel pro)
{
try
{
string sql = "update project set EnglistName='" + pro.EnglistName + "',ProjectTitle='" + pro.ProjectTitle + "',ProjectContent='" + pro.ProjectContent + "',`Date`='" + pro.Date + "',Image='" + pro.Image + "',ProjectProfile='" + pro.ProjectProfile + "',ProjectKeyWord='" + pro.ProjectKeyWord + "',ProjectAuthor='" + pro.ProjectAuthor + "',ProjectSource='" + pro.ProjectSource + "' where ProjectID=" + pro.ProjectID + "";
int h = MySqlDB.nonquery(sql, CommandType.Text, null);
return(h);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加移民项目
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int AddPro(JiaJiModels.ProjectModel pro)
{
try
{
string sql = " insert into project(EnglistName,ProjectTitle,ProjectContent,Date,Image,ProjectProfile,ProjectKeyWord,ProjectReadCount,ProjectAuthor,ProjectSource) values('" + pro.EnglistName + "','" + pro.ProjectTitle + "','" + pro.ProjectContent + "','" + pro.Date + "','" + pro.Image + "','" + pro.ProjectProfile + "','" + pro.ProjectKeyWord + "',0,'" + pro.ProjectAuthor + "','" + pro.ProjectSource + "')";
int h = MySqlDB.nonquery(sql, CommandType.Text, null);
return(h);
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加移民项目
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int AddPro(JiaJiModels.ProjectModel pro)
{
return(dal.AddPro(pro));
}