/// <summary> ///根据id修改一条数据(返)修改结果) /// </summary> public bool Update(Models.OperationLog Models) { string sqlStr = " update [MS_OperationLog] set GUID=@GUID,IP_ADDRESS=@IP_ADDRESS,CITY=@CITY,OPERATION_URL=@OPERATION_URL,PARAM_STRING=@PARAM_STRING,RESULT_STRING=@RESULT_STRING,STATE=@STATE where id = @id"; using (var connection = new ConnectionCode().GetConnection()) { return(connection.Execute(sqlStr, Models) > 0); } }
/// <summary> ///添加一条数据(返)插入的数据的id) /// </summary> public int Add(Models.OperationLog Models) { string sqlStr = " insert into [MS_OperationLog](GUID,IP_ADDRESS,CITY,OPERATION_URL,PARAM_STRING,RESULT_STRING,STATE) values(@GUID,@IP_ADDRESS,@CITY,@OPERATION_URL,@PARAM_STRING,@RESULT_STRING,@STATE);select @@identity "; using (var connection = new ConnectionCode().GetConnection()) { return(connection.Query <int>(sqlStr, Models).SingleOrDefault()); } }