public void AddOperateRecord(string ip, UserOperateType operateType)
{
T1_OperateRecord LM_OperateRecord = new T1_OperateRecord()
{
T_User_Name = LoginInfo.UserName,
T_User_Code = LoginInfo.UserCode,
OperateTime = DateTime.Now,
OperateType = (short)operateType,
};
_databaseComponent.Add <T_OperateRecord>(ip, LM_OperateRecord);
}
public async Task <List <T1_OperateRecord> > GetOperateRecord(string ip, DateTime start, DateTime end, string name, UserOperateType operateType)
{
List <T_OperateRecord> list = new List <T_OperateRecord>();
if (name.Trim() == "" && operateType == UserOperateType.None)
{
list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "(OperateTime >= @0 and OperateTime <= @1)", new object[] { start, end, });
}
else if (name.Trim() != "" && operateType == UserOperateType.None)
{
list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and T_User_Name like '%'+ @2+ '%')", new object[] { start, end, name });
}
else if (name.Trim() == "" && operateType != UserOperateType.None)
{
list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and UserOperateType = @2)", new object[] { start, end, ((short)operateType) });
}
else
{
list = await _databaseComponent.Query <T_OperateRecord>(ip, null, "((OperateTime >= @0 and OperateTime <= @1) and T_User_Name like '%'+ @2+ '%' and UserOperateType = @3)", new object[] { start, end, name, ((short)operateType).ToString() });
}
return(list.Select(p => ClassCopyHelper.AutoCopy <T_OperateRecord, T1_OperateRecord>(p)).ToList());
}
