public object DelGameInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "游戏机流水号不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(); if (!data_GameInfoService.Any(a => a.ID == iId)) { errMsg = "该游戏机信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var data_GameInfo = data_GameInfoService.GetModels(p => p.ID == iId).FirstOrDefault(); if (!data_GameInfoService.Delete(data_GameInfo)) { errMsg = "删除游戏机信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetStoreWeightGameList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty; if (string.IsNullOrEmpty(storeId)) { errMsg = "门店ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true); IBase_StoreWeight_GameService base_StoreWeight_GameService = BLLContainer.Resolve <IBase_StoreWeight_GameService>(resolveNew: true); var result = from a in data_GameInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) join b in base_StoreWeight_GameService.GetModels() on a.ID equals b.GameID into b1 from b in b1.DefaultIfEmpty() where b.GameID == (int?)null select new { GameName = a.GameName, GameID = a.ID }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetStoreGameInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(); Dictionary <int, string> gameInfo = data_GameInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)).Select(o => new { ID = o.ID, GameName = o.GameName }).Distinct().ToDictionary(d => d.ID, d => d.GameName); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, gameInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetStoreWeightUserGameList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty; string userId = dicParas.ContainsKey("userId") ? (dicParas["userId"] + "") : string.Empty; if (string.IsNullOrEmpty(storeId)) { errMsg = "门店ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(userId)) { errMsg = "用户ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iUserId = Convert.ToInt32(userId); IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>(resolveNew: true); IBase_StoreWeight_GameService base_StoreWeight_GameService = BLLContainer.Resolve <IBase_StoreWeight_GameService>(resolveNew: true); IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true); var result = from a in base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.BossID == iUserId) join b in base_StoreWeight_GameService.GetModels() on a.ID equals b.WeightID join c in data_GameInfoService.GetModels() on b.GameID equals c.ID select new { GameName = c.GameName, GameID = c.ID }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetGameInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "游戏机流水号不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true); if (!data_GameInfoService.Any(a => a.ID == iId)) { errMsg = "该游戏机信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } IDict_SystemService dict_SystemService = BLLContainer.Resolve <IDict_SystemService>(resolveNew: true); int GameInfoId = dict_SystemService.GetModels(p => p.DictKey.Equals("游戏机档案维护")).FirstOrDefault().ID; var result = from a in data_GameInfoService.GetModels(p => p.ID == iId).FirstOrDefault().AsDictionary() join b in dict_SystemService.GetModels(p => p.PID == GameInfoId) on a.Key equals b.DictKey into b1 from b in b1.DefaultIfEmpty() select new { name = a.Key, value = a.Value, comment = b != null ? b.Comment : string.Empty }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetGameInfoList(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; IDict_SystemService dict_SystemService = BLLContainer.Resolve <IDict_SystemService>(resolveNew: true); int GameTypeId = dict_SystemService.GetModels(p => p.DictKey.Equals("游戏机类型")).FirstOrDefault().ID; IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true); var data_GameInfo = from a in data_GameInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) join b in dict_SystemService.GetModels(p => p.PID == GameTypeId) on a.GameType equals b.DictValue into b1 from b in b1.DefaultIfEmpty() orderby a.GameID select new { ID = a.ID, GameID = a.GameID, GameName = a.GameName, GameTypeStr = b != null ? b.DictKey : string.Empty, PushReduceFromCard = a.PushReduceFromCard, AllowElecPushStr = a.AllowElecPush != null ? (a.AllowElecPush == 1 ? "启用" : "禁用") : "", LotteryModeStr = a.LotteryMode != null ? (a.LotteryMode == 1 ? "启用" : "禁用") : "", ReadCatStr = a.ReadCat != null ? (a.ReadCat == 1 ? "启用" : "禁用") : "", StateStr = !string.IsNullOrEmpty(a.State) ? (a.State == "1" ? "启用" : "禁用") : "" }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_GameInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object ReloadDevice(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string userId = userTokenKeyModel.LogId; int iUserId = 0; int.TryParse(userId, out iUserId); string errMsg = string.Empty; string goodId = dicParas.ContainsKey("goodId") ? Convert.ToString(dicParas["goodId"]) : string.Empty; string deviceId = dicParas.ContainsKey("deviceId") ? Convert.ToString(dicParas["deviceId"]) : string.Empty; string deviceType = dicParas.ContainsKey("deviceType") ? Convert.ToString(dicParas["deviceType"]) : string.Empty; string reloadType = dicParas.ContainsKey("reloadType") ? Convert.ToString(dicParas["reloadType"]) : string.Empty; string reloadCount = dicParas.ContainsKey("reloadCount") ? Convert.ToString(dicParas["reloadCount"]) : string.Empty; string note = dicParas.ContainsKey("note") ? Convert.ToString(dicParas["note"]) : string.Empty; int iDeviceId = 0, iGoodId = 0; int.TryParse(deviceId, out iDeviceId); int.TryParse(goodId, out iGoodId); #region 参数验证 if (string.IsNullOrEmpty(goodId)) { errMsg = "商品索引goodId不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //if (string.IsNullOrEmpty(deviceId)) //{ // errMsg = "设备索引deviceId不能为空"; // return ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg); //} if (string.IsNullOrEmpty(deviceType)) { errMsg = "设备类型deviceType不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(reloadType)) { errMsg = "安装类别reloadType不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(reloadCount)) { errMsg = "安装数量reloadCount不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (!Utils.isNumber(reloadCount)) { errMsg = "安装数量reloadCount格式不正确"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iReloadCount = Convert.ToInt32(reloadCount); if (iReloadCount < 0) { errMsg = "安装数量reloadCount不能为负数"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } #endregion IBase_StorageInfoService base_StorageInfoService = BLLContainer.Resolve <IBase_StorageInfoService>(); IData_Storage_RecordService data_Storage_RecordService = BLLContainer.Resolve <IData_Storage_RecordService>(); IData_ReloadService data_ReloadService = BLLContainer.Resolve <IData_ReloadService>(); IData_HeadService data_HeadService = BLLContainer.Resolve <IData_HeadService>(resolveNew: true); IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(resolveNew: true); int?iDepotId = (from a in data_HeadService.GetModels(p => p.ID == iDeviceId) join b in data_GameInfoService.GetModels() on a.GameIndexID equals b.ID select b.DepotID).FirstOrDefault(); //开启EF事务 using (TransactionScope ts = new TransactionScope()) { try { var data_Reload = new Data_Reload(); data_Reload.StoreID = storeId; data_Reload.GoodID = Convert.ToInt32(goodId); data_Reload.DeviceID = !string.IsNullOrEmpty(deviceId) ? Convert.ToInt32(deviceId) : (int?)null; data_Reload.DeviceType = Convert.ToInt32(deviceType); data_Reload.ReloadType = Convert.ToInt32(reloadType); data_Reload.ReloadCount = iReloadCount; data_Reload.Note = note; data_Reload.RealTime = DateTime.Now; data_Reload.UserID = iUserId; if (!data_ReloadService.Add(data_Reload)) { errMsg = "添加设备安装信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //更新库存 if (base_StorageInfoService.Any(a => a.DepotID == iDepotId && a.GoodID == iGoodId)) { var base_StorageInfo = base_StorageInfoService.GetModels(p => p.DepotID == iDepotId && p.GoodID == iGoodId).FirstOrDefault(); base_StorageInfo.Surplus -= iReloadCount; if (!base_StorageInfoService.Update(base_StorageInfo)) { errMsg = "更新库存信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //添加库存记录 var data_Storage_Record = new Data_Storage_Record(); data_Storage_Record.StorageCount = iReloadCount; data_Storage_Record.StorageFlag = (int)StockFlag.Out; data_Storage_Record.StorageID = base_StorageInfo.ID; data_Storage_Record.CreateTime = DateTime.Now; if (!data_Storage_RecordService.Add(data_Storage_Record)) { errMsg = "添加库存记录失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } ts.Complete(); } catch (Exception ex) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message)); } } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (DbEntityValidationException e) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, e.EntityValidationErrors.ToErrors())); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object SaveGameInfo(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; string gameId = dicParas.ContainsKey("GameID") ? (dicParas["GameID"] + "") : string.Empty; string id = dicParas.ContainsKey("ID") ? (dicParas["ID"] + "") : string.Empty; string gameName = dicParas.ContainsKey("GameName") ? (dicParas["GameName"] + "") : string.Empty; if (string.IsNullOrEmpty(gameId)) { errMsg = "游戏机编号GameID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (gameId.Length > 4) { errMsg = "游戏机编号GameID不能超过4个字符"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(gameName)) { errMsg = "游戏机名称GameName不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (!string.IsNullOrEmpty(id) && !Utils.isNumber(id)) { errMsg = "游戏机参数ID格式不正确"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } IData_GameInfoService data_GameInfoService = BLLContainer.Resolve <IData_GameInfoService>(); var data_GameInfo = new Data_GameInfo(); if (string.IsNullOrEmpty(id)) { if (data_GameInfoService.Any(a => a.GameID.Equals(gameId, StringComparison.OrdinalIgnoreCase))) { errMsg = "该游戏机编号已使用"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } Utils.GetModel(dicParas, ref data_GameInfo); data_GameInfo.StoreID = storeId; if (!data_GameInfoService.Add(data_GameInfo)) { errMsg = "新增游戏机信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } else { int iId = Convert.ToInt32(id); if (!data_GameInfoService.Any(a => a.ID == iId)) { errMsg = "该游戏机不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (data_GameInfoService.Any(a => a.ID != iId && a.GameID.Equals(gameId, StringComparison.OrdinalIgnoreCase))) { errMsg = "该游戏机编号已使用"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } data_GameInfo = data_GameInfoService.GetModels(p => p.ID == iId).FirstOrDefault(); Utils.GetModel(dicParas, ref data_GameInfo); data_GameInfo.StoreID = storeId; if (!data_GameInfoService.Update(data_GameInfo)) { errMsg = "修改游戏机信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (DbEntityValidationException e) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, e.EntityValidationErrors.ToErrors())); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }