public IActionResult About()
{
ViewData["Message"] = "Your application description page.";
var dic = Log2Net.LogApi.GetLogWebApplicationsName();
var curDal = new Log_OperateTraceAdoDal();
DBOperUser dbUser = new DBOperUser()
{
UserId = "CNNO2", UserName = "******"
};
#region 测试获取数据
var dbData = curDal.GetAll(new LogORM.Models.PageSerach <Log_OperateTrace>()
{
Filter = a => a.Id > 0,
OrderBy = a => a.OrderByDescending(m => m.LogTime),
PageSize = 2
});
var dbModels = DtModelConvert <List <Log_OperateTrace> > .DeepClone(dbData.ExeModel);
var selectModels = dbModels.ConvertAll(a => (object)a);
#endregion 测试获取数据
#region 测试添加更新删除
LogORM.Models.AddDBPara <Log_OperateTrace> addDBPara = new LogORM.Models.AddDBPara <Log_OperateTrace>()
{
Model = new Log_OperateTrace()
{
ClientHost = "江南可采莲",
Detail = "鱼戏莲叶间",
ClientIP = "鱼戏莲叶东西南北中间",
LogTime = System.DateTime.Now,
LogType = LogType.添加,
ServerHost = "鱼戏莲叶下上左右后前",
ServerIP = "鱼莲玩嗨乐翻天",
SystemID = SysCategory.SysA_02,
TabOrModu = "莲叶变黄了_DNC",
UserID = "鱼还没戏够",
UserName = "******",
}
};
var resAdd = curDal.Add(addDBPara, new DBOperUser()
{
UserId = "CN666", UserName = "******"
});
var resUpdate = curDal.Update(new Dictionary <string, object>()
{
{ "id", 2 }
}, new Dictionary <string, object>()
{
{ "Detail", "后事如何，下回分解" }
});
var delRes = curDal.Delete(new Dictionary <string, object>()
{
{ "id", 2 }
}, dbUser);
var delRes2 = curDal.Delete(3, dbUser);
#endregion 测试添加更新删除
#region 测试批量添加和更新
Log_OperateTrace curAddLog = new Log_OperateTrace()
{
ClientHost = "江南可采莲",
Detail = "鱼戏莲叶间",
ClientIP = "鱼戏莲叶东西南北中间",
LogTime = System.DateTime.Now,
LogType = LogType.添加,
ServerHost = "鱼戏莲叶下上左右后前",
ServerIP = "鱼莲玩嗨乐翻天",
SystemID = SysCategory.SysA_02,
TabOrModu = "莲叶变黄了_DNC",
UserID = "鱼还没戏够",
UserName = "******",
};
List <AddUpdateDelEdm> AddUpdateDelEdms = new List <AddUpdateDelEdm>();
AddUpdateDelEdms.Add(new AddUpdateDelEdm()
{
TableName = "Log_OperateTrace", Datas = new List <object>()
{
curAddLog
}
});
var resBtAdd = curDal.AddUpdateDelete(new DBOperUser()
{
UserId = "CN1234", UserName = "******"
}, AddUpdateDelEdms.ToArray());
//以下为更新
AddUpdateDelEdms.Add(new AddUpdateDelEdm()
{
TableName = "Log_OperateTrace", Datas = selectModels
});
AddUpdateDelEdms[0].Datas = (selectModels);
AddUpdateDelEdms[0].UpdateFD = new List <Dictionary <string, string> > {
new Dictionary <string, string> {
{ "ServerIP", "1.1.1.1" }
}
};
var resBtUpdate = curDal.AddUpdateDelete(new DBOperUser()
{
UserId = "CN12348", UserName = "******"
}, AddUpdateDelEdms.ToArray());
#endregion 测试批量添加和更新
#region 测试存储过程
DbParameter[] spParameters = new SqlParameter[] { new SqlParameter("@userid", "CN4096"), new SqlParameter("@bok", System.Data.SqlDbType.Int) };
spParameters[1].Direction = System.Data.ParameterDirection.Output;
spParameters[1].Value = 0;
var spRes = curDal.ExecuteStoredProcedure("getInsertLog", true, new DBOperUser()
{
UserId = "CN8192", UserName = "******"
}, spParameters);
#endregion 测试存储过程
#region 测试日志记录
LogTraceVM model = new LogTraceVM()
{
Detail = "所有的程序员都是天才编剧，所有的计算机都是烂演员",
LogType = LogType.业务记录,
Remark = "文学奖评选",
TabOrModu = "计算机编程",
};
var logRes = new ComClass().WriteLog(LogLevel.Info, model);
#endregion 测试日志记录
//测试获取Sql
var sql = curDal.CurSqlProvider.Select("username", "realname", "age").From("sys_user").Where <KeyValue>(a => a.Name == "username1").SqlString;
return(View());
}
//将Log_OperateTraceR内容写到队列中
protected override ExeResEdm WriteLog(Log_OperateTrace model)
{
return(SendLogToQueue(model, MQType.TraceLog));
}
//写轨迹数据到MS SQL和InfluxDB
protected void WriteTraceDataToDB(Log_OperateTrace obj)
{
base.WriteLog(obj);
return;
}
//写Log_OperateTraceR日志 protected abstract ExeResEdm WriteLog(Log_OperateTrace model);
