/// <summary>
///根据id修改一条数据(返)修改结果）
/// </summary>
public bool Update(Models.ReaderLog Models)
{
string sqlStr = " update [MS_ReaderLog] set ENTRY_URL=@ENTRY_URL,ARTICE_ID=@ARTICE_ID,PROJECT_ID=@PROJECT_ID,VISIT_IP=@VISIT_IP,VISIT_CITY=@VISIT_CITY,SESSION_GUID=@SESSION_GUID,STATE=@STATE,OUT_TIME=@OUT_TIME where id = @id";
using (var connection = new ConnectionCode().GetConnection())
{
return(connection.Execute(sqlStr, Models) > 0);
}
}
/// <summary>
///添加一条数据(返)插入的数据的id）
/// </summary>
public int Add(Models.ReaderLog Models)
{
string sqlStr = " insert into [MS_ReaderLog](ENTRY_URL,ARTICE_ID,PROJECT_ID,VISIT_IP,VISIT_CITY,SESSION_GUID,STATE,OUT_TIME) values(@ENTRY_URL,@ARTICE_ID,@PROJECT_ID,@VISIT_IP,@VISIT_CITY,@SESSION_GUID,@STATE,@OUT_TIME);select @@identity ";
using (var connection = new ConnectionCode().GetConnection())
{
return(connection.Query <int>(sqlStr, Models).SingleOrDefault());
}
}
