/// <summary>
///根据id修改一条数据(返)修改结果）
/// </summary>
public bool Update(Models.ProjectDetail Models)
{
string sqlStr = " update [MS_ProjectDetail] set CREATE_GUID=@CREATE_GUID,TITLE=@TITLE,CONTENT=@CONTENT,PROJECT_URL=@PROJECT_URL,DEMO_URL=@DEMO_URL,STATE=@STATE,LAST_CHANGE_TIME=@LAST_CHANGE_TIME,LAST_CHANGE_IP=@LAST_CHANGE_IP,LAST_CHANGE_GUID=@LAST_CHANGE_GUID where id = @id";
using (var connection = new ConnectionCode().GetConnection())
{
return(connection.Execute(sqlStr, Models) > 0);
}
}
/// <summary>
///添加一条数据(返)插入的数据的id）
/// </summary>
public int Add(Models.ProjectDetail Models)
{
string sqlStr = " insert into [MS_ProjectDetail](CREATE_GUID,TITLE,CONTENT,PROJECT_URL,DEMO_URL,STATE,LAST_CHANGE_TIME,LAST_CHANGE_IP,LAST_CHANGE_GUID) values(@CREATE_GUID,@TITLE,@CONTENT,@PROJECT_URL,@DEMO_URL,@STATE,@LAST_CHANGE_TIME,@LAST_CHANGE_IP,@LAST_CHANGE_GUID);select @@identity ";
using (var connection = new ConnectionCode().GetConnection())
{
return(connection.Query <int>(sqlStr, Models).SingleOrDefault());
}
}
