using System; using System.Collections.Generic; using System.Linq; using Library; using MySystem.PxcModels; namespace MySystem { public class Utils { public readonly static Utils Instance = new Utils(); private Utils() { } /// /// 操作收支明细 /// /// /// /// public void OpAccount(int UserId, decimal Money, int ChangeType, bool IsTotal = true) { WebCMSEntities db = new WebCMSEntities(); UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId); if (account == null) { account = db.UserAccount.Add(new UserAccount() { Id = UserId, UserId = UserId, }).Entity; db.SaveChanges(); } decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额 decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额 decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额 account.BalanceAmount += Money; if(IsTotal) { account.TotalAmount += Money; } decimal AfterTotalAmount = account.TotalAmount; //变更后总金额 decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额 decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额 UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord() { CreateDate = DateTime.Now, UpdateDate = DateTime.Now, UserId = UserId, //创客 ChangeType = ChangeType, //变动类型 ChangeAmount = Money, //变更金额 BeforeTotalAmount = BeforeTotalAmount, //变更前总金额 AfterTotalAmount = AfterTotalAmount, //变更后总金额 BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额 AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额 BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额 AfterBalanceAmount = AfterBalanceAmount, //变更后余额 }).Entity; db.SaveChanges(); db.Dispose(); } public void ToChargeAmount(int UserId, decimal Money) { WebCMSEntities db = new WebCMSEntities(); UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId); if (account == null) { account = db.UserAccount.Add(new UserAccount() { Id = UserId, UserId = UserId, }).Entity; db.SaveChanges(); } account.ToChargeAmount += Money; db.SaveChanges(); db.Dispose(); } /// /// 预设职级 /// /// /// public void LeaderPreUserLevel(int UserId, int UserLevel, DateTime ExpiredDate) { WebCMSEntities db = new WebCMSEntities(); UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId); if(rank == null) { rank = db.UserRankWhite.Add(new UserRankWhite() { CreateDate = DateTime.Now, //设置时间 UserId = UserId, //用户 Id = UserId, }).Entity; db.SaveChanges(); } rank.Rank = UserLevel; rank.UpdateDate = ExpiredDate; db.SaveChanges(); db.Dispose(); } #region 获取创客职级 public int GetUserLevel(int Id) { WebCMSEntities db = new WebCMSEntities(); DateTime now = DateTime.Now; List Levels = new List(); Users user = db.Users.FirstOrDefault(m => m.Id == Id) ?? new Users(); UserRankWhite userRank = db.UserRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new UserRankWhite(); LeaderRankWhite leaderRank = db.LeaderRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new LeaderRankWhite(); OperatorRankWhite operatorRank = db.OperatorRankWhite.FirstOrDefault(m => m.Id == Id && m.UpdateDate > now) ?? new OperatorRankWhite(); Levels.Add(user.UserLevel); Levels.Add(userRank.Rank); Levels.Add(leaderRank.Rank); Levels.Add(operatorRank.Rank); db.Dispose(); return Levels.Max(); } #endregion #region 解析机具押金值,单位转换 public string TransferDeposit(PosMachinesTwo newpos, string Deposit) { decimal DepositNumber = decimal.Parse(function.CheckNum(Deposit)); if(DepositNumber == 0) { return ""; } WebCMSEntities db = new WebCMSEntities(); int BrandId = newpos.BrandId; KqProducts pro = db.KqProducts.FirstOrDefault(m => m.Id == BrandId) ?? new KqProducts(); if(pro.NoticeMoneyUnit == 1 && DepositNumber > 1000) { DepositNumber = DepositNumber / 100; } if(pro.NoticeMoneyUnit == 2 && DepositNumber < 1000) { DepositNumber = DepositNumber * 100; } db.Dispose(); return DepositNumber.ToString("f2"); } #endregion #region 打控制台日志 public static void WriteLog(string msg, string filename = "message") { Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "--" + filename + "--" + msg); } #endregion } }