public JArray GetKWSLog(KWSLogType kWSLogType, string engNum = null, DateTime? fromDt = null, DateTime? toDt = null) { var result = KRepKWSLog.GetKWSLog(kWSLogType, engNum, fromDt, toDt); if (result == null) return null; var retModel = JArray.FromObject(result); return retModel; }
public static List<KWSLog> GetKWSLog(KWSLogType kWSLogType, string engNum = null, DateTime? fromDt = null, DateTime? toDt = null) { var fDate = fromDt.GetValueOrDefault(DateTime.MinValue).ToUniversalTime(); var tDate = toDt.GetValueOrDefault(DateTime.Now).GetToDate().ToUniversalTime(); using (KDBContext db = new KDBContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { List<KWSLog> result = null; if (!string.IsNullOrWhiteSpace(engNum)) { if (kWSLogType == KWSLogType.CreateWS) result = db.KWSLog.Where(x => x.EngNum == engNum && (x.KWSLogType == KWSLogType.CreateWSAuto || x.KWSLogType == KWSLogType.CreateWSManual || x.KWSLogType == KWSLogType.CreateWSFail) && x.InsertWhen >= fDate && x.InsertWhen <= tDate ) .OrderByDescending(x => x.InsertWhen).ToList(); else result = db.KWSLog.Where(x => x.EngNum == engNum && x.KWSLogType == kWSLogType && x.InsertWhen >= fDate && x.InsertWhen <= tDate ).OrderByDescending(x => x.InsertWhen).ToList(); } else { if (kWSLogType == KWSLogType.CreateWS) result = db.KWSLog.Where(x => (x.KWSLogType == KWSLogType.CreateWSAuto || x.KWSLogType == KWSLogType.CreateWSManual || x.KWSLogType == KWSLogType.CreateWSFail) && x.InsertWhen >= fDate && x.InsertWhen <= tDate ) .OrderByDescending(x => x.InsertWhen).ToList(); else result = db.KWSLog.Where(x => x.KWSLogType == kWSLogType && x.InsertWhen >= fDate && x.InsertWhen <= tDate ).OrderByDescending(x => x.InsertWhen).ToList(); } return result; } } }
public static void KWSLogAddDeleteUser(string num, string groupName, string userId, KWSLogType kWSLogType) { KWSLogAddDeleteUser kWSLogAddDeleteUser = new KWSLogAddDeleteUser { GroupName = groupName, UserId = userId }; KWSLog kWSLog = new KWSLog { EngNum = num, KWSLogType = kWSLogType, Info = KSerDSer.JSerialize<KWSLogAddDeleteUser>(kWSLogAddDeleteUser), }; KWSLog(kWSLog); }
public void KWSLogAddDeleteUser(string num, string groupName, string userId, KWSLogType kWSLogType) { KRepKWSLog.KWSLogAddDeleteUser(num, groupName, userId, kWSLogType); }