public object QueryJackpotInfo(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string merchId = userTokenKeyModel.DataModel.MerchID; string errMsg = string.Empty; object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null; SqlParameter[] parameters = new SqlParameter[1]; string sqlWhere = string.Empty; parameters[0] = new SqlParameter("@MerchId", merchId); if (conditions != null && conditions.Length > 0) { if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } string sql = @"select a.* from Data_JackpotInfo a where a.MerchInfo=@MerchId"; sql = sql + sqlWhere; IData_JackpotInfoService data_JackpotInfoService = BLLContainer.Resolve <IData_JackpotInfoService>(); var data_JackpotInfo = data_JackpotInfoService.SqlQuery <Data_JackpotInfo>(sql, parameters).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_JackpotInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DelChainStore(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "门店连锁规则ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IBase_ChainRule_StoreService base_ChainRule_StoreService = BLLContainer.Resolve <IBase_ChainRule_StoreService>(); if (!base_ChainRule_StoreService.Any(a => a.ID == iId)) { errMsg = "该门店连锁规则不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var base_ChainRule_StoreModel = base_ChainRule_StoreService.GetModels(p => p.ID == iId).FirstOrDefault(); if (!base_ChainRule_StoreService.Delete(base_ChainRule_StoreModel)) { errMsg = "删除接收余额的门店失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DelGoodsInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "商品ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>(); if (!base_GoodsInfoService.Any(a => a.ID == iId)) { errMsg = "该商品信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var base_GoodsInfo = base_GoodsInfoService.GetModels(p => p.ID == iId).FirstOrDefault(); base_GoodsInfo.Status = 0; if (!base_GoodsInfoService.Update(base_GoodsInfo)) { errMsg = "删除游戏机信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetStoreWeightList(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)); } IBase_UserInfoService base_UserInfoService = BLLContainer.Resolve <IBase_UserInfoService>(resolveNew: true); IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>(resolveNew: true); var result = from a in base_UserInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.UserType == (int)UserType.StoreBoss) join b in base_StoreWeightService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) on a.UserID equals b.BossID select new { RealName = a.RealName, LogName = a.LogName, WeightValue = b.WeightValue, ID = b.ID }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DelPushRule(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_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>(); if (!data_Push_RuleService.Any(a => a.ID == iId)) { errMsg = "该投币规则信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var data_Push_Rule = data_Push_RuleService.GetModels(p => p.ID == iId).FirstOrDefault(); if (!data_Push_RuleService.Delete(data_Push_Rule)) { errMsg = "删除投币规则信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DeletePicture(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string fileName = dicParas.ContainsKey("fileName") ? dicParas["fileName"].ToString() : string.Empty; if (fileName == null) { errMsg = "图片名称不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } string picturePath = System.Configuration.ConfigurationManager.AppSettings["UploadImageUrl"].ToString() + "/XCCloud/"; string path = System.Web.HttpContext.Current.Server.MapPath(picturePath); IData_BillInfoService data_BillInfoService = BLLContainer.Resolve <IData_BillInfoService>(); SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@PicturePath", picturePath + fileName); data_BillInfoService.ExecuteSqlCommand("update Data_BillInfo set PicturePath='' where PicturePath=@PicturePath", parameters); if (File.Exists(path + fileName)) { File.Delete(path + fileName); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetMemberDic(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string merchId = userTokenKeyModel.DataModel.MerchID; IBase_StoreInfoService base_StoreInfoService = BLLContainer.Resolve <IBase_StoreInfoService>(resolveNew: true); IBase_MemberInfoService base_MemberInfoService = BLLContainer.Resolve <IBase_MemberInfoService>(resolveNew: true); IData_Member_CardService data_Member_CardService = BLLContainer.Resolve <IData_Member_CardService>(resolveNew: true); IData_Member_Card_StoreService data_Member_Card_StoreService = BLLContainer.Resolve <IData_Member_Card_StoreService>(resolveNew: true); var linq = from a in base_StoreInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)) join b in data_Member_Card_StoreService.GetModels() on a.StoreID equals b.StoreID join c in data_Member_CardService.GetModels() on b.CardID equals c.ID join d in base_MemberInfoService.GetModels() on c.MemberID equals d.ID select new { MemberID = d.ID, MemberName = d.UserName }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, linq)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetMemberLevelInfo(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; string memberLevelID = dicParas.ContainsKey("memberLevelID") ? dicParas["memberLevelID"].ToString() : string.Empty; if (string.IsNullOrEmpty(memberLevelID)) { errMsg = "会员级别ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iMemberLevelID = Convert.ToInt32(memberLevelID); IData_MemberLevelService data_MemberLevelService = BLLContainer.Resolve <IData_MemberLevelService>(); if (!data_MemberLevelService.Any(a => a.MemberLevelID == iMemberLevelID)) { errMsg = "该会员级别不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var data_MemberLevelModel = data_MemberLevelService.GetModels(p => p.MemberLevelID == iMemberLevelID).FirstOrDefault(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_MemberLevelModel)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetProjectInfoList(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; var data_ProjectInfoService = BLLContainer.Resolve <IData_ProjectInfoService>(resolveNew: true); var dict_SystemService = BLLContainer.Resolve <IDict_SystemService>(resolveNew: true); int FeeTypeId = dict_SystemService.GetModels(p => p.DictKey.Equals("计费方式")).FirstOrDefault().ID; var linq = from a in data_ProjectInfoService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.ProjectStatus == 1) join b in dict_SystemService.GetModels(p => p.PID == FeeTypeId) on(a.FeeType + "") equals b.DictValue into b1 from b in b1.DefaultIfEmpty() select new { ID = a.ID, ProjectName = a.ProjectName, ProjectStatusStr = a.ProjectStatus == 1 ? "有效" : "无效", FeeCycle = a.FeeCycle, FeeDeposit = a.FeeDeposit, SignOutEnStr = a.SignOutEN == 1 ? "需要签出" : "单次扣费", WhenLockStr = a.WhenLock == 1 ? "是" : "否", RegretTime = a.RegretTime, Note = a.Note, FeeTypeStr = b != null ? b.DictKey : string.Empty }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, linq.ToList())); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object QueryPushRule(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null; SqlParameter[] parameters = new SqlParameter[0]; string sqlWhere = string.Empty; if (conditions != null && conditions.Length > 0) { if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } string sql = @"select b.GameID, b.GameName, a.ID, a.MemberLevelName, a.Week, a.Allow_Out, a.Allow_In, a.Coin, a.Level, a.StartTime as ST, a.EndTime as ET from Data_Push_Rule a " + " inner join Data_GameInfo b on a.GameIndexID=b.ID " + " where b.StoreID='" + storeId + "'"; sql = sql + sqlWhere; IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>(); var data_Push_Rule = data_Push_RuleService.SqlQuery <Data_Push_RuleList>(sql, parameters).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Push_Rule)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetGameHeadInfo(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; string gameIndexId = dicParas.ContainsKey("gameIndexId") ? Convert.ToString(dicParas["gameIndexId"]) : string.Empty; int iGameIndexId = 0; int.TryParse(gameIndexId, out iGameIndexId); IData_HeadService data_HeadService = BLLContainer.Resolve <IData_HeadService>(); Dictionary <int, string> gameHeadInfo = data_HeadService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.GameIndexID == iGameIndexId).Select(o => new { ID = o.ID, HeadName = o.HeadName }).Distinct().ToDictionary(d => d.ID, d => d.HeadName); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, gameHeadInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object unBindStore(Dictionary <string, object> dicParas) { try { string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; if (string.IsNullOrEmpty(storeId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "storeId参数不能为空")); } int iStoreId = Convert.ToInt32(storeId); IStoreService storeService = BLLContainer.Resolve <IStoreService>(); if (!storeService.Any(a => a.id == iStoreId)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "该门店不存在")); } var storeInfo = storeService.GetModels(p => p.id == iStoreId).FirstOrDefault(); storeInfo.openId = string.Empty; if (!storeService.Update(storeInfo)) { return(ResponseModelFactory.CreateModel(isSignKeyReturn, Return_Code.T, "", Result_Code.F, "解绑门店失败")); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object QueryWorkstation(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null; SqlParameter[] parameters = new SqlParameter[0]; string sqlWhere = string.Empty; if (conditions != null && conditions.Length > 0) { if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } string sql = @"select a.* from Data_Workstation a where a.StoreID='" + storeId + "'"; sql = sql + sqlWhere; IData_WorkstationService data_WorkstationService = BLLContainer.Resolve <IData_WorkstationService>(); var data_Workstation = data_WorkstationService.SqlQuery(sql, parameters).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Workstation)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetOrdersChart(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string merchId = userTokenKeyModel.DataModel.MerchID; DateTime now = DateTime.Now; DateTime start = new DateTime(now.Year, now.Month, 1); DateTime end = start.AddMonths(1).AddDays(-1); TimeSpan ts = end.Subtract(start); int num = ts.Days; List <Store_CheckDateChartModel> store_CheckDateChart = new List <Store_CheckDateChartModel>(); var base_StoreInfo = BLLContainer.Resolve <IBase_StoreInfoService>().GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)).Select(o => o.StoreID); var store_CheckDate = BLLContainer.Resolve <IStore_CheckDateService>().GetModels(p => base_StoreInfo.Contains(p.StoreID) && System.Data.Entity.DbFunctions.DiffMonths(p.CheckDate, DateTime.Now) == 0); for (int i = 0; i <= num; i++) { DateTime da = start.AddDays(i).Date; var query = store_CheckDate.Where(p => System.Data.Entity.DbFunctions.DiffDays(p.CheckDate, da) == 0); Store_CheckDateChartModel store_CheckDateModel = new Store_CheckDateChartModel(); store_CheckDateModel.CheckDate = da; store_CheckDateModel.AliPay = (decimal)query.Sum(s => s.AliPay).GetValueOrDefault(); store_CheckDateModel.Wechat = (decimal)query.Sum(s => s.Wechat).GetValueOrDefault(); store_CheckDateChart.Add(store_CheckDateModel); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, store_CheckDateChart)); } 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 GetUserGroupList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string logId = string.Empty; int userId = (dicParas.ContainsKey("userId") && Utils.isNumber(dicParas["userId"])) ? Convert.ToInt32(dicParas["userId"]) : 0; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; if (userTokenKeyModel.LogType == (int)RoleType.MerchUser) { logId = userTokenKeyModel.DataModel.MerchID; } //EF左关联 var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserGroup).Namespace); var base_UserGroup = (from a in dbContext.Set <Base_UserGroup>() join b in dbContext.Set <Base_UserInfo>().Where(p => p.UserID == userId) on a.ID equals b.UserGroupID into t from b in t.DefaultIfEmpty() where a.MerchID.Equals(logId, StringComparison.OrdinalIgnoreCase) select new UserGroupModel { ID = a.ID, GroupName = a.GroupName, Note = a.Note, UserState = (b.UserID > 0 ? 1 : 0) }).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_UserGroup)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetCouponInfo(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_CouponInfoService data_CouponInfoService = BLLContainer.Resolve <IData_CouponInfoService>(); var data_CouponInfo = data_CouponInfoService.GetModels(p => p.ID == iId).FirstOrDefault(); if (data_CouponInfo == null) { errMsg = "该优惠券不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_CouponInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetGoodsInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "商品ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>(); if (!base_GoodsInfoService.Any(a => a.ID == iId)) { errMsg = "该商品信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var result = from a in base_GoodsInfoService.GetModels(p => p.ID == iId).FirstOrDefault().AsDictionary() select new { name = a.Key, value = a.Value }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DelMerch(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string merchId = dicParas.ContainsKey("merchId") ? dicParas["merchId"].ToString() : string.Empty; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string createUserId = userTokenKeyModel.LogId; #region 验证参数 if (string.IsNullOrWhiteSpace(merchId)) { errMsg = "商户编号不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (!string.IsNullOrEmpty(merchId) && merchId.Length > 11) { errMsg = "商户编号不能超过11个字符"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } #endregion IBase_MerchantInfoService base_MerchantInfoService = BLLContainer.Resolve <IBase_MerchantInfoService>(); if (base_MerchantInfoService.Any(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase))) { var base_MerchantInfoModel = base_MerchantInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (base_MerchantInfoModel.CreateType == (int)CreateType.Agent && !base_MerchantInfoModel.CreateUserID.Equals(createUserId, StringComparison.OrdinalIgnoreCase)) //代理商创建 { errMsg = "该商户只有所属代理商能删除"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } base_MerchantInfoModel.MerchStatus = (int)MerchState.Stop; if (!base_MerchantInfoService.Update(base_MerchantInfoModel)) { errMsg = "删除商户信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } else { errMsg = "该商户信息不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //更新缓存 MerchBusiness.Init(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetDigitDestroy(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string destroyTime = dicParas.ContainsKey("destroyTime") ? (dicParas["destroyTime"] + "") : string.Empty; string iCardID = dicParas.ContainsKey("iCardID") ? (dicParas["iCardID"] + "") : string.Empty; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; if (!string.IsNullOrEmpty(destroyTime)) { try { Convert.ToDateTime(destroyTime); } catch { errMsg = "销毁时间参数格式不正确"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } IData_DigitCoinDestroyService data_DigitCoinDestroyService = BLLContainer.Resolve <IData_DigitCoinDestroyService>(); var query = data_DigitCoinDestroyService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)); if (!string.IsNullOrEmpty(destroyTime)) { var dt = Convert.ToDateTime(destroyTime); query = query.Where(w => DbFunctions.DiffDays(w.DestroyTime, dt) == 0); } if (!string.IsNullOrEmpty(iCardID)) { query = query.Where(w => w.ICCardID.Contains(iCardID)); } IBase_UserInfoService base_UserInfoService = BLLContainer.Resolve <IBase_UserInfoService>(); var linq = base_UserInfoService.GetModels(p => p.UserType == (int)UserType.Store).Select(o => new { UserID = o.UserID, LogName = o.LogName, RealName = o.RealName }); var result = query.ToList().Select(o => new { ID = o.ID, StoreID = o.StoreID, ICardID = o.ICCardID, DestroyTime = o.DestroyTime, UserID = o.UserID, Note = o.Note, LogName = linq.SingleOrDefault(p => p.UserID == o.UserID).LogName, RealName = linq.SingleOrDefault(p => p.UserID == o.UserID).RealName }); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result.ToList())); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetBindDeviceList(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; string type = dicParas.ContainsKey("type") ? (dicParas["type"] + "") : string.Empty; string mcuId = dicParas.ContainsKey("mcuId") ? (dicParas["mcuId"] + "") : string.Empty; var bindDeviceIDs = dicParas.ContainsKey("bindDeviceIDs") ? ((object[])dicParas["bindDeviceIDs"]).Cast <int>() : null; if (!string.IsNullOrEmpty(type) && !Utils.isNumber(type)) { errMsg = "设备类型格式不正确"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_UserInfo).Namespace); var data_Project_Device = from a in dbContext.Set <Data_Project_Device>() join b in dbContext.Set <Data_ProjectInfo>() on a.ProjectID equals b.ID where b.ProjectStatus == 1 select a.DeviceID; var base_DeviceInfo = dbContext.Set <Base_DeviceInfo>().Where(p => p.DeviceStatus == (int)DeviceStatus.Normal && p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && !data_Project_Device.Contains(p.ID)); if (!string.IsNullOrEmpty(type)) { int iType = Convert.ToInt32(type); base_DeviceInfo = base_DeviceInfo.Where(w => w.type == iType); } if (!string.IsNullOrEmpty(mcuId)) { base_DeviceInfo = base_DeviceInfo.Where(w => w.MCUID.Contains(mcuId)); } if (bindDeviceIDs != null) { base_DeviceInfo = base_DeviceInfo.Where(w => !bindDeviceIDs.Contains(w.ID)); } int DeviceTypeId = dbContext.Set <Dict_System>().Where(p => p.DictKey.Equals("设备类型")).FirstOrDefault().ID; var linq = from a in base_DeviceInfo join b in dbContext.Set <Dict_System>().Where(p => p.PID == DeviceTypeId) on(a.type + "") equals b.DictValue into b1 from b in b1.DefaultIfEmpty() select new { ID = a.ID, DeviceName = a.DeviceName, typeStr = b != null ? b.DictKey : string.Empty, MCUID = a.MCUID }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, linq.ToList())); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DelStoreWeight(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; #region 验证参数 if (string.IsNullOrEmpty(id)) { errMsg = "门店权重ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } #endregion //开启EF事务 using (TransactionScope ts = new TransactionScope()) { try { IBase_StoreWeightService base_StoreWeightService = BLLContainer.Resolve <IBase_StoreWeightService>(); int iId = Convert.ToInt32(id); var base_StoreWeight = base_StoreWeightService.GetModels(p => p.ID == iId).FirstOrDefault(); if (!base_StoreWeightService.Delete(base_StoreWeight)) { errMsg = "删除门店权重信息失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_StoreWeight_Game).Namespace); var base_StoreWeight_Game = dbContext.Set <Base_StoreWeight_Game>().Where(p => p.WeightID == iId).ToList(); foreach (var model in base_StoreWeight_Game) { dbContext.Entry(model).State = EntityState.Deleted; } if (dbContext.SaveChanges() < 0) { 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 (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object SetParam(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string storeId = dicParas.ContainsKey("storeId") ? dicParas["storeId"].ToString() : string.Empty; string system = dicParas.ContainsKey("system") ? dicParas["system"].ToString() : string.Empty; string isAllow = dicParas.ContainsKey("isAllow") ? dicParas["isAllow"].ToString() : string.Empty; string pValue = dicParas.ContainsKey("pValue") ? dicParas["pValue"].ToString() : string.Empty; string note = dicParas.ContainsKey("note") ? dicParas["note"].ToString() : string.Empty; //验证参数信息 if (!checkParams(dicParas, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(system)) { errMsg = "控件名称不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } IData_ParametersService data_ParameterService = BLLContainer.Resolve <IData_ParametersService>(); var data_Parameter = data_ParameterService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase) && p.System.Equals(system, StringComparison.OrdinalIgnoreCase)).ToList(); int count = data_Parameter.Count; if (count == 0) { errMsg = "参数" + system + "数据库不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (count > 1) { errMsg = "参数" + system + "数据库存在多个"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var data_ParameterModel = data_Parameter.FirstOrDefault(); data_ParameterModel.IsAllow = !string.IsNullOrEmpty(isAllow) ? Convert.ToInt32(isAllow) : (int?)null; data_ParameterModel.ParameterValue = pValue; data_ParameterModel.Note = note; if (!data_ParameterService.Update(data_ParameterModel)) { errMsg = "设置参数失败"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetUnChainStoreList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string storeId = dicParas.ContainsKey("storeId") ? (dicParas["storeId"] + "") : string.Empty; string ruleType = dicParas.ContainsKey("ruleType") ? (dicParas["ruleType"] + "") : string.Empty; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string merchId = userTokenKeyModel.DataModel.MerchID; if (string.IsNullOrEmpty(storeId)) { errMsg = "门店ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (string.IsNullOrEmpty(ruleType)) { errMsg = "规则类别不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (!Utils.isNumber(ruleType)) { errMsg = "规则类别格式不正确"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iRuleType = Convert.ToInt32(ruleType); IBase_StoreInfoService base_StoreInfoService = BLLContainer.Resolve <IBase_StoreInfoService>(resolveNew: true); IBase_ChainRuleService base_ChainRuleService = BLLContainer.Resolve <IBase_ChainRuleService>(resolveNew: true); IBase_ChainRule_StoreService base_ChainRule_StoreService = BLLContainer.Resolve <IBase_ChainRule_StoreService>(resolveNew: true); var result = from a in base_StoreInfoService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase)) join b in ( from a in base_ChainRuleService.GetModels(p => p.MerchID.Equals(merchId, StringComparison.OrdinalIgnoreCase) && p.RuleType == iRuleType) join b in base_ChainRule_StoreService.GetModels(p => p.StoreID.Equals(storeId, StringComparison.OrdinalIgnoreCase)) on a.RuleGroupID equals b.RuleGroupID join c in base_ChainRule_StoreService.GetModels() on b.RuleGroupID equals c.RuleGroupID select c ) on a.StoreID equals b.StoreID into b1 from b in b1.DefaultIfEmpty() where string.IsNullOrEmpty(b.StoreID) select new { StoreID = a.StoreID, StoreName = a.StoreName }; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetUserGroup(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string errMsg = string.Empty; string groupId = dicParas.ContainsKey("groupId") ? dicParas["groupId"].ToString() : string.Empty; if (string.IsNullOrEmpty(groupId)) { errMsg = "groupId参数不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } string sql = string.Empty; SqlParameter[] parameters = new SqlParameter[0]; if (userTokenKeyModel.LogType == (int)RoleType.MerchUser) { string merchId = userTokenKeyModel.DataModel.MerchID; sql = " exec SelectUserGroupGrant @GroupID,@MerchID"; Array.Resize(ref parameters, parameters.Length + 1); parameters[parameters.Length - 1] = new SqlParameter("@GroupID", groupId); Array.Resize(ref parameters, parameters.Length + 1); parameters[parameters.Length - 1] = new SqlParameter("@MerchID", merchId); } else if (userTokenKeyModel.LogType == (int)RoleType.XcAdmin) { sql = " exec SelectFunctionForXA @GroupID"; Array.Resize(ref parameters, parameters.Length + 1); parameters[parameters.Length - 1] = new SqlParameter("@GroupID", groupId); } //返回商户信息和功能菜单信息 System.Data.DataSet ds = XCCloudBLL.ExecuteQuerySentence(sql, parameters); if (ds.Tables.Count != 2) { errMsg = "获取数据异常"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //实例化一个根节点 var userGroupModel = Utils.GetModelList <UserGroupModel>(ds.Tables[0]).FirstOrDefault() ?? new UserGroupModel(); UserGroupGrantModel rootRoot = new UserGroupGrantModel(); rootRoot.ParentID = 0; TreeHelper.LoopToAppendChildren(Utils.GetModelList <UserGroupGrantModel>(ds.Tables[1]), rootRoot); userGroupModel.UserGroupGrants = rootRoot.Children; return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, userGroupModel)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object DeleteRoot(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; int id = (dicParas.ContainsKey("id") && Utils.isNumber(dicParas["id"])) ? Convert.ToInt32(dicParas["id"]) : 0; if (id == 0) { errMsg = "选中节点id不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } //开启EF事务 using (TransactionScope ts = new TransactionScope()) { try { var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Dict_System).Namespace); if (!dbContext.Set <Dict_System>().Any(p => p.ID == id)) { errMsg = "选中节点数据库不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } var dict_System = dbContext.Set <Dict_System>().Where(p => p.PID == id).ToList(); foreach (var item in dict_System) { dbContext.Entry(item).State = EntityState.Deleted; } var dict_SystemModel = dbContext.Set <Dict_System>().Where(p => p.ID == id).FirstOrDefault(); dbContext.Entry(dict_SystemModel).State = EntityState.Deleted; if (dbContext.SaveChanges() < 0) { 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 (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object QueryFreeRule(Dictionary <string, object> dicParas) { try { XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID; string errMsg = string.Empty; object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null; SqlParameter[] parameters = new SqlParameter[0]; string sqlWhere = string.Empty; if (conditions != null && conditions.Length > 0) { if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } string sql = @"select c.ID, b.GameID, b.GameName, d.MemberLevelName as MemberLevelName, (case c.RuleType when 0 then '模拟机' when 1 then '博彩机' else '' end) as RuleTypeStr, " + " c.NeedCoin, c.FreeCoin, c.ExitCoin, c.StartTime as ST, c.EndTime as ET, c.State from Data_GameFreeRule_List a " + " inner join Data_GameInfo b on a.GameIndexID=b.ID " + " inner join Data_GameFreeRule c on a.RuleID=c.ID " + " left join Data_MemberLevel d on c.MemberLevelID=d.MemberLevelID" + " where b.StoreID='" + storeId + "'"; sql = sql + sqlWhere; IData_GameFreeRuleService data_GameFreeRuleService = BLLContainer.Resolve <IData_GameFreeRuleService>(); var data_GameFreeRule = data_GameFreeRuleService.SqlQuery <Data_GameFreeRuleList>(sql, parameters).ToList(); var linq = from a in data_GameFreeRule group a by new { ID = a.ID } into g select new { g.Key.ID, GameID = string.Join("|", g.Select(p => p.GameID)), GameName = string.Join("|", g.Select(p => p.GameName)), MemberLevelName = g.Max(p => p.MemberLevelName), RuleTypeStr = g.Max(p => p.RuleTypeStr), NeedCoin = g.Max(p => p.NeedCoin), FreeCoin = g.Max(p => p.FreeCoin), ExitCoin = g.Max(p => p.ExitCoin), StartTime = g.Max(p => p.StartTime), EndTime = g.Max(p => p.EndTime), State = g.Max(p => p.State) }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, linq)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetJackpotInfo(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty; if (string.IsNullOrEmpty(id)) { errMsg = "规则ID不能为空"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } int iId = Convert.ToInt32(id); IData_JackpotInfoService data_JackpotInfoService = BLLContainer.Resolve <IData_JackpotInfoService>(); var data_JackpotInfo = data_JackpotInfoService.GetModels(p => p.ID == iId).FirstOrDefault(); if (data_JackpotInfo == null) { errMsg = "该抽奖规则不存在"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } IData_Jackpot_LevelService data_Jackpot_LevelService = BLLContainer.Resolve <IData_Jackpot_LevelService>(resolveNew: true); IBase_GoodsInfoService base_GoodsInfoService = BLLContainer.Resolve <IBase_GoodsInfoService>(resolveNew: true); var JackpotLevels = from a in data_Jackpot_LevelService.GetModels(p => p.ActiveID == iId) join b in base_GoodsInfoService.GetModels() on a.GoodID equals b.ID select new { LevelName = a.LevelName, GoodCount = a.GoodCount, Probability = a.Probability, GoodID = a.GoodID, GoodName = b.GoodName }; var result = new { ID = data_JackpotInfo.ID, ActiveName = data_JackpotInfo.ActiveName, Threshold = data_JackpotInfo.Threshold, Concerned = data_JackpotInfo.Concerned, StartTime = data_JackpotInfo.StartTime, EndTime = data_JackpotInfo.EndTime, JackpotLevels = JackpotLevels }; return(ResponseModelFactory.CreateAnonymousSuccessModel(isSignKeyReturn, result)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object GetMerchList(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null; XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel]; //代理商仅能查所属商户,普通商户或大客户只能查自己,莘宸管理员可以查所有商户 SqlParameter[] parameters = new SqlParameter[0]; string sqlWhere = string.Empty; if (userTokenKeyModel.LogType == (int)RoleType.MerchUser) { var merchIdDataModel = userTokenKeyModel.DataModel as MerchDataModel; Array.Resize(ref parameters, parameters.Length + 1); if (merchIdDataModel.MerchType == (int)MerchType.Agent) { parameters[parameters.Length - 1] = new SqlParameter("@logId", userTokenKeyModel.LogId); sqlWhere = sqlWhere + " and a.CreateUserID=@logId"; } else { parameters[parameters.Length - 1] = new SqlParameter("@merchId", merchIdDataModel.MerchID); sqlWhere = sqlWhere + " and a.MerchID=@merchId"; } } if (conditions != null && conditions.Length > 0) { if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg)) { return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } } string sql = @"select a.MerchID, a.MerchName, a.Mobil, b.DictKey as MerchTypeStr, a.MerchAccount, d.DictKey as AllowCreateSubStr, a.AllowCreateCount, c.DictKey as MerchStatusStr from Base_MerchantInfo a " + " left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户类别' and a.PID=0) b on convert(varchar, a.MerchType)=b.DictValue " + " left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='商户状态' and a.PID=0) c on convert(varchar, a.MerchStatus)=c.DictValue " + " left join (select b.* from Dict_System a inner join Dict_System b on a.ID=b.PID where a.DictKey='创建子账号' and a.PID=0) d on convert(varchar, a.AllowCreateSub)=d.DictValue " + " where 1=1 "; sql = sql + sqlWhere; var dbContext = DbContextFactory.CreateByModelNamespace(typeof(Base_MerchantInfo).Namespace); var base_MerchantInfo = dbContext.Database.SqlQuery <Base_MerchantInfoListModel>(sql, parameters).ToList(); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, base_MerchantInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }
public object UploadCardCover(Dictionary <string, object> dicParas) { try { string errMsg = string.Empty; #region 验证参数 var file = HttpContext.Current.Request.Files[0]; if (file == null) { errMsg = "未找到图片"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } if (file.ContentLength > int.Parse(System.Configuration.ConfigurationManager.AppSettings["MaxImageSize"].ToString())) { errMsg = "超过图片的最大限制为1M"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } #endregion string picturePath = System.Configuration.ConfigurationManager.AppSettings["UploadImageUrl"].ToString() + "/XCCloud/Store/Member/"; string path = System.Web.HttpContext.Current.Server.MapPath(picturePath); //如果不存在就创建file文件夹 if (Directory.Exists(path) == false) { Directory.CreateDirectory(path); } string fileName = Path.GetFileNameWithoutExtension(file.FileName) + Utils.ConvertDateTimeToLong(DateTime.Now) + Path.GetExtension(file.FileName); if (File.Exists(path + fileName)) { errMsg = "图片名称已存在,请重命名后上传"; return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg)); } file.SaveAs(path + fileName); Dictionary <string, string> dicStoreInfo = new Dictionary <string, string>(StringComparer.OrdinalIgnoreCase); dicStoreInfo.Add("CardUIURL", picturePath + fileName); return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, dicStoreInfo)); } catch (Exception e) { return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message)); } }