public string GetApi()
{
//进行测试
var _apiLog = new Models.ApiLog
{
ClientIP = "111111",
ResponseTime = 12,
AccessToken = "aaa",
AccessTime = DateTime.Now.AddMilliseconds(-12),
AccessApiUrl = "aaa",
AccessAction = "aaa",
AccessParameterGet = "",
AccessParameterPost = "",
HttpStatus = 200
};
//_db.Insertable(_apiLog).EnableDiffLogEvent("ApiLog").ExecuteCommand();
_apiLog.ClientIP = "33333";
var list = new List <string>()
{
"ClientIP"
};
// _db.Updateable(_apiLog).Where(x => x.ALgID >= 76997).UpdateColumns(list.ToArray()).EnableDiffLogEvent("ApiLog").ExecuteCommand();
var dt = _db.Ado.ExecuteCommand("delete ApiLog where ALgID >=76994");
_db.Deleteable <ApiLog>(x => x.ALgID >= 76997).EnableDiffLogEvent("ApiLog").ExecuteCommand();
return("string");
}
public string GetApi()
{
//进行测试
var _apiLog = new Models.ApiLog
{
ClientIP = "111111",
ResponseTime = 12,
AccessToken = "aaa",
AccessTime = DateTime.Now.AddMilliseconds(-12),
AccessApiUrl = "aaa",
AccessAction = "aaa",
AccessParameterGet = "",
AccessParameterPost = "",
HttpStatus = 200
};
//_db.Insertable(_apiLog).ExecuteCommand();
_db.Aop.OnLogExecuted = (sql, pars) => //SQL执行完事件
{
var aa = _db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
};
_db.Aop.OnLogExecuting = (sql, pars) => //SQL执行前事件
{
var aa = _db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
};
_db.Ado.IsEnableLogEvent = true;
_apiLog.ClientIP = "33333";
var list = new List <string>()
{
"ClientIP"
};
_db.Updateable(_apiLog).Where(x => x.ALgID >= 77001).UpdateColumns(list.ToArray()).ExecuteCommand();
//var dt = _db.Ado.ExecuteCommand("update ApiLog set ClientIP=@ClientIP where ALgID>=76994",
// new List<SugarParameter>(){
// new SugarParameter("@ClientIP","aaaa") //参数
// });
//var dt = _db.Ado.ExecuteCommand("delete ApiLog where ALgID >=@ALgID", new List<SugarParameter>(){
// new SugarParameter("@ALgID", "76994")
//});
//_db.Deleteable<ApiLog>(x => x.ALgID >= 76997).ExecuteCommand();
return("string");
}
public string GetApi()
{
//进行测试
var _apiLog = new Models.ApiLog
{
ClientIP = "111111",
ResponseTime = 12,
AccessToken = "aaa",
AccessTime = DateTime.Now.AddMilliseconds(-12),
AccessApiUrl = "aaa",
AccessAction = "aaa",
AccessParameterGet = "",
AccessParameterPost = "",
HttpStatus = 200
};
int nus = _db.Insertable(_apiLog).ExecuteCommand();
_logService.Add(new DataLog.Models.DataLog()
{
DataID = "abc", DataJson = "aaaa"
});
_apiLog.ClientIP = "33333";
var list = new List <string>()
{
"ClientIP"
};
//_db.Updateable(_apiLog).Where(x => x.ALgID >= 77001).UpdateColumns(list.ToArray()).ExecuteCommand();
//var dt = _db.Ado.ExecuteCommand("update ApiLog set ClientIP=@ClientIP where ALgID>=76994",
// new List<SugarParameter>(){
// new SugarParameter("@ClientIP","aaaa") //参数
// });
//var dt = _db.Ado.ExecuteCommand("delete ApiLog where ALgID >=@ALgID", new List<SugarParameter>(){
// new SugarParameter("@ALgID", "76994")
//});
//_db.Deleteable<ApiLog>(x => x.ALgID >= 76997).ExecuteCommand();
return("string");
}
public string Get()
{
//进行测试
var _apiLog = new Models.ApiLog
{
ClientIP = "111111",
ResponseTime = 12,
AccessToken = "aaa",
AccessTime = DateTime.Now.AddMilliseconds(-12),
AccessApiUrl = "aaa",
AccessAction = "aaa",
AccessParameterGet = "",
AccessParameterPost = "",
HttpStatus = 200
};
_db.Insertable(_apiLog).ExecuteCommand();
return("string");
}
