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()); }