/// <summary> /// /// </summary> public static void AddSingleRow(this UPPReqBase req) { using (var dbContext = new DbContextContainer(DbKind.MySql, DbName.UPPDb)._DataAccess) { try { var dbReq = new Db_AppLog { AppId = req.AppId, Channel = req.Channel, Class = req.Class, Kind = req.Kind, Mode = req.Mode, OperCode = req.OperCode, ReqTime = Convert.ToDateTime(req.ReqTime), TermCode = req.TermCode, ReqArgs = req.Args, ReqRandom = req.Random, ReqSign = req.Sign, AddDate = DateTime.Now }; dbContext.Entry(dbReq).State = EntityState.Added; dbContext.SaveChanges(); req.RowId = dbReq.Id; } catch (Exception ex) { LogModule.Error("Db Fail:" + ex.Message + (ex.InnerException == null ? "" : ex.InnerException.Message) + "\r\n参数:" + req.EntityToKeyValue(false)); } } }
/// <summary> /// /// </summary> /// <param name="res"></param> public static void ModSingleRow(this UPPResBase res, UPPReqBase req) { using (var dbContext = new DbContextContainer(DbKind.MySql, DbName.UPPDb)._DataAccess) { try { var dbRow = dbContext.Set <Db_AppLog>().Where(w => w.Id == req.RowId).ToList().FirstOrDefault(); if (dbRow == null) { throw new Exception("The line that needs to be modified does not exist!"); } dbRow.Code = res.ResCode; dbRow.Msg = res.ResMsg; dbRow.ResTime = Convert.ToDateTime(res.ResTime); dbRow.ResArgs = res.Args; dbRow.ResRandom = res.Random; dbRow.ResSign = res.Sign; dbRow.ModDate = DateTime.Now; dbContext.SaveChanges(); } catch (Exception ex) { LogModule.Error("Db Fail:" + ex.Message + (ex.InnerException == null ? "" : ex.InnerException.Message)); } } }
/// <summary> /// entity convert to key=value and return sign /// </summary> /// <param name="req"></param> /// <param name="key"></param> /// <param name="mode"></param> /// <returns></returns> public static string EntityToKeyValueOfSign(this UPPReqBase req, string key, int mode) { req.Mode = mode.ToString(); return(req.EntityToKeyValue(key).BuildCipher("", CipherKind.MD5)); }