/// <summary> /// 更新游戏 /// </summary> /// <param name="gameGameItem"></param> public void UpdateGameKindItem(GameKindItem gameKindItem) { StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("UPDATE GameKindItem SET ") .Append("GameID=@GameID, ") .Append("TypeID=@TypeID, ") .Append("SortID=@SortID, ") .Append("KindName=@KindName, ") .Append("JoinID=@JoinID, ") .Append("ProcessName=@ProcessName, ") .Append("GameRuleUrl=@GameRuleUrl, ") .Append("DownLoadUrl=@DownLoadUrl, ") .Append("Nullity=@Nullity ") .Append("WHERE KindID=@KindID"); var prams = new List <DbParameter>(); prams.Add(Database.MakeInParam("GameID", gameKindItem.GameID)); prams.Add(Database.MakeInParam("TypeID", gameKindItem.TypeID)); prams.Add(Database.MakeInParam("SortID", gameKindItem.SortID)); prams.Add(Database.MakeInParam("KindName", gameKindItem.KindName)); prams.Add(Database.MakeInParam("JoinID", gameKindItem.JoinID)); prams.Add(Database.MakeInParam("ProcessName", gameKindItem.ProcessName)); prams.Add(Database.MakeInParam("GameRuleUrl", gameKindItem.GameRuleUrl)); prams.Add(Database.MakeInParam("DownLoadUrl", gameKindItem.DownLoadUrl)); prams.Add(Database.MakeInParam("Nullity", gameKindItem.Nullity)); prams.Add(Database.MakeInParam("KindID", gameKindItem.KindID)); Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray()); }
/// <summary> /// 获取游戏实体 /// </summary> /// <param name="gameID"></param> /// <returns></returns> public GameKindItem GetGameKindItemInfo(int kindID) { string sqlQuery = string.Format("(NOLOCK) WHERE KindID= {0}", kindID); GameKindItem gameKindItem = aideGameKindItemProvider.GetObject <GameKindItem>(sqlQuery); return(gameKindItem); }
/// <summary> /// 获取积分库的连接串 /// </summary> /// <param name="kindID"></param> /// <returns></returns> public string GetConn(int kindID) { StringBuilder sb = new StringBuilder(); GameKindItem gamekind = GetGameKindItemInfo(kindID); if (gamekind == null) { return(""); } GameGameItem game = GetGameGameItemInfo(gamekind.GameID); if (game == null) { return(""); } DataBaseInfo database = GetDataBaseInfo(game.DataBaseAddr); if (database == null) { return(""); } string userID = Utils.CWHEncryptNet.XorCrevasse(database.DBUser); string password = Utils.CWHEncryptNet.XorCrevasse(database.DBPassword); sb.AppendFormat("Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3}; Pooling=true", game.DataBaseAddr + (string.IsNullOrEmpty(database.DBPort.ToString()) ? "" : ("," + database.DBPort.ToString())), game.DataBaseName, userID, password); return(sb.ToString()); }
public string GetConn(int kindID) { StringBuilder stringBuilder = new StringBuilder(); GameKindItem gameKindItemInfo = aidePlatformFacade.GetGameKindItemInfo(kindID); GameGameItem gameGameItemInfo = aidePlatformFacade.GetGameGameItemInfo(gameKindItemInfo.GameID); stringBuilder.AppendFormat("Data Source={0}; Initial Catalog={1}; User ID={2}; Password={3}; Pooling=true", gameGameItemInfo.DataBaseAddr, gameGameItemInfo.DataBaseName, "sa", "3112546"); return(stringBuilder.ToString()); }
/// <summary> /// 获取游戏名称 /// </summary> /// <param name="kindID"></param> /// <returns></returns> protected string GetGameKindName(int kindID) { GameKindItem gameKind = aidePlatformFacade.GetGameKindItemInfo(kindID); if (gameKind == null) { return(""); } return(gameKind.KindName); }
public static string GetGameKindName(int kindID) { GameKindItem gameKindItemInfo = FacadeManage.aidePlatformFacade.GetGameKindItemInfo(kindID); if (gameKindItemInfo == null) { return(""); } return(gameKindItemInfo.KindName); }
public bool IsExistsKindID(int kindID) { GameKindItem gameKindItemInfo = GetGameKindItemInfo(kindID); if (gameKindItemInfo == null) { return(false); } return(true); }
/// <summary> /// 判断游戏标识KindID是否存在,true-存在,false-不存在 /// </summary> /// <param name="kindID"></param> /// <returns></returns> public bool IsExistsKindID(int kindID) { GameKindItem item = GetGameKindItemInfo(kindID); if (item == null) { return(false); } else { return(true); } }
/// <summary> /// 获取游戏名称 /// </summary> /// <param name="serverID"></param> /// <returns></returns> protected string GameGameNameByServerID(int serverID) { GameRoomInfo gameRoomInfo = FacadeManage.aidePlatformFacade.GetGameRoomInfoInfo(serverID); if (gameRoomInfo != null) { GameKindItem gameKindItem = FacadeManage.aidePlatformFacade.GetGameKindItemInfo(gameRoomInfo.KindID); if (gameKindItem != null) { return(gameKindItem.KindName); } } return(""); }
/// <summary> /// 新增游戏 /// </summary> /// <param name="gameGameItem"></param> public void InsertGameKindItem(GameKindItem gameKindItem) { DataRow dr = aideGameKindItemProvider.NewRow(); dr[GameKindItem._KindID] = gameKindItem.KindID; dr[GameKindItem._GameID] = gameKindItem.GameID; dr[GameKindItem._TypeID] = gameKindItem.TypeID; dr[GameKindItem._SortID] = gameKindItem.SortID; dr[GameKindItem._KindName] = gameKindItem.KindName; dr[GameKindItem._JoinID] = gameKindItem.JoinID; dr[GameKindItem._ProcessName] = gameKindItem.ProcessName; dr[GameKindItem._GameRuleUrl] = gameKindItem.GameRuleUrl; dr[GameKindItem._DownLoadUrl] = gameKindItem.DownLoadUrl; dr[GameKindItem._Nullity] = gameKindItem.Nullity; aideGameKindItemProvider.Insert(dr); }
private void GameKindItemDataBind( ) { if (StrCmd == "add") { litInfo.Text = "新增"; txtKindID.Enabled = true; } else { litInfo.Text = "更新"; txtKindID.Enabled = false; } if (IntParam <= 0) { return; } //获取游戏信息 GameKindItem gameKindItem = aidePlatformFacade.GetGameKindItemInfo(IntParam); if (gameKindItem == null) { ShowError("游戏信息不存在"); Redirect("GameKindItemList.aspx"); return; } CtrlHelper.SetText(txtKindID, gameKindItem.KindID.ToString( ).Trim( )); CtrlHelper.SetText(txtKindName, gameKindItem.KindName.Trim( )); ddlTypeID.SelectedValue = gameKindItem.TypeID.ToString( ).Trim( ); ddlJoin.SelectedValue = gameKindItem.JoinID.ToString( ).Trim( ); CtrlHelper.SetText(txtSortID, gameKindItem.SortID.ToString( ).Trim( )); ddlGameID.SelectedValue = gameKindItem.GameID.ToString( ).Trim( ); CtrlHelper.SetText(txtProcessName, gameKindItem.ProcessName.Trim( )); CtrlHelper.SetText(txtGameRuleUrl, gameKindItem.GameRuleUrl.Trim( )); CtrlHelper.SetText(txtDownLoadUrl, gameKindItem.DownLoadUrl.Trim( )); rbtnNullity.SelectedValue = gameKindItem.Nullity.ToString( ).Trim( ); }
/// <summary> /// 更新游戏 /// </summary> /// <param name="gameGameItem"></param> public Message UpdateGameKindItem(GameKindItem gameKindItem) { aidePlatformData.UpdateGameKindItem(gameKindItem); return(new Message(true)); }
/// <summary> /// 新增游戏 /// </summary> /// <param name="gameGameItem"></param> public Message InsertGameKindItem(GameKindItem gameKindItem) { aidePlatformData.InsertGameKindItem(gameKindItem); return(new Message(true)); }
private void ProcessData( ) { string kindID = CtrlHelper.GetText(txtKindID); string sortID = CtrlHelper.GetText(txtSortID); if (!Utils.Validate.IsPositiveInt(kindID)) { ShowError("游戏标识不规范,游戏标识只能为正整数"); return; } if (!Utils.Validate.IsPositiveInt(sortID)) { ShowError("排序输入不规范,排序只能为0或正整数"); return; } GameKindItem gameKindItem = new GameKindItem( ); gameKindItem.KindID = Convert.ToInt32(kindID); gameKindItem.KindName = CtrlHelper.GetText(txtKindName); gameKindItem.TypeID = Convert.ToInt32(ddlTypeID.SelectedValue.Trim( )); gameKindItem.JoinID = Convert.ToInt32(ddlJoin.SelectedValue.Trim( )); gameKindItem.SortID = CtrlHelper.GetInt(txtSortID, 0); gameKindItem.GameID = Convert.ToInt32(ddlGameID.SelectedValue.Trim( )); gameKindItem.ProcessName = CtrlHelper.GetText(txtProcessName); gameKindItem.GameRuleUrl = CtrlHelper.GetText(txtGameRuleUrl); gameKindItem.DownLoadUrl = CtrlHelper.GetText(txtDownLoadUrl); gameKindItem.Nullity = Convert.ToByte(rbtnNullity.SelectedValue.Trim( )); Message msg = new Message( ); if (StrCmd == "add") { //判断权限 AuthUserOperationPermission(Permission.Add); if (aidePlatformFacade.IsExistsKindID(gameKindItem.KindID)) { ShowError("游戏标识已经存在"); return; } msg = aidePlatformFacade.InsertGameKindItem(gameKindItem); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); msg = aidePlatformFacade.UpdateGameKindItem(gameKindItem); } if (msg.Success) { if (StrCmd == "add") { ShowInfo("游戏信息增加成功", "GameKindItemList.aspx", 1200); } else { ShowInfo("游戏信息修改成功", "GameKindItemList.aspx", 1200); } } else { ShowError(msg.Content); } }
private void GameKindItemDataBind() { if (StrCmd == "add") { litInfo.Text = "新增"; txtKindID.Enabled = true; } else { litInfo.Text = "更新"; txtKindID.Enabled = false; } if (IntParam <= 0) { return; } //获取游戏信息 GameKindItem gameKindItem = FacadeManage.aidePlatformFacade.GetGameKindItemInfo(IntParam); if (gameKindItem == null) { ShowError("游戏信息不存在"); Redirect("GameKindItemList.aspx"); return; } CtrlHelper.SetText(txtKindID, gameKindItem.KindID.ToString().Trim()); CtrlHelper.SetText(txtKindName, gameKindItem.KindName.Trim()); ddlTypeID.SelectedValue = gameKindItem.TypeID.ToString().Trim(); ddlJoin.SelectedValue = gameKindItem.JoinID.ToString().Trim(); int gameFlag = gameKindItem.GameFlag; if (cblGameFlag.Items.Count > 0) { foreach (ListItem item in cblGameFlag.Items) { item.Selected = int.Parse(item.Value) == (gameFlag & int.Parse(item.Value)); } } CtrlHelper.SetText(txtSortID, gameKindItem.SortID.ToString().Trim()); ddlGameID.SelectedValue = gameKindItem.GameID.ToString().Trim(); CtrlHelper.SetText(txtProcessName, gameKindItem.ProcessName.Trim()); CtrlHelper.SetText(txtGameRuleUrl, gameKindItem.GameRuleUrl.Trim()); CtrlHelper.SetText(txtDownLoadUrl, gameKindItem.DownLoadUrl.Trim()); rbtnNullity.SelectedValue = gameKindItem.Nullity.ToString().Trim(); ckbRecommend.Checked = gameKindItem.Recommend == 1 ? true : false; GameConfig gameConfig = FacadeManage.aidePlatformFacade.GetGameConfig(IntParam); if (gameConfig != null) { CtrlHelper.SetText(txtNoticeChangeGolds, gameConfig.NoticeChangeGolds.ToString()); CtrlHelper.SetText(txtWinExperience, gameConfig.WinExperience.ToString()); } else { SystemStatusInfo systemStatusInfo = FacadeManage.aideAccountsFacade.GetSystemStatusInfo(EnumerationList.SystemStatusKey.WinExperience.ToString()); if (systemStatusInfo != null) { CtrlHelper.SetText(txtWinExperience, systemStatusInfo.StatusValue.ToString()); } else { CtrlHelper.SetText(txtWinExperience, "10"); } } }
private void ProcessData() { if (!IsValid) { return; } string kindID = CtrlHelper.GetText(txtKindID); string sortID = CtrlHelper.GetText(txtSortID); if (!Utils.Validate.IsPositiveInt(kindID)) { ShowError("游戏标识不规范,游戏标识只能为正整数"); return; } if (!Utils.Validate.IsPositiveInt(sortID)) { ShowError("排序输入不规范,排序只能为0或正整数"); return; } GameKindItem gameKindItem = new GameKindItem(); gameKindItem.KindID = Convert.ToInt32(kindID); gameKindItem.KindName = CtrlHelper.GetText(txtKindName); gameKindItem.TypeID = Convert.ToInt32(ddlTypeID.SelectedValue.Trim()); gameKindItem.JoinID = Convert.ToInt32(ddlJoin.SelectedValue.Trim()); //计算属性 int gameFlag = 0; if (cblGameFlag.Items.Count > 0) { foreach (ListItem item in cblGameFlag.Items) { if (item.Selected) { gameFlag |= int.Parse(item.Value); } } } gameKindItem.GameFlag = gameFlag; gameKindItem.SortID = CtrlHelper.GetInt(txtSortID, 0); gameKindItem.GameID = Convert.ToInt32(ddlGameID.SelectedValue.Trim()); gameKindItem.ProcessName = CtrlHelper.GetText(txtProcessName); gameKindItem.GameRuleUrl = CtrlHelper.GetText(txtGameRuleUrl); gameKindItem.DownLoadUrl = CtrlHelper.GetText(txtDownLoadUrl); gameKindItem.Nullity = Convert.ToByte(rbtnNullity.SelectedValue.Trim()); gameKindItem.Recommend = ckbRecommend.Checked ? 1 : 0; Message msg = new Message(); if (StrCmd == "add") { //判断权限 AuthUserOperationPermission(Permission.Add); if (FacadeManage.aidePlatformFacade.IsExistsKindID(gameKindItem.KindID)) { ShowError("游戏标识已经存在"); return; } msg = FacadeManage.aidePlatformFacade.InsertGameKindItem(gameKindItem); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); msg = FacadeManage.aidePlatformFacade.UpdateGameKindItem(gameKindItem); } if (msg.Success) { //更新游戏配置 GameConfig gameConfig = new GameConfig(); gameConfig.KindID = gameKindItem.KindID; gameConfig.NoticeChangeGolds = Convert.ToInt64(txtNoticeChangeGolds.Text); gameConfig.WinExperience = Convert.ToInt32(txtWinExperience.Text.Trim()); FacadeManage.aidePlatformFacade.UpdateGameConfig(gameConfig); if (StrCmd == "add") { ShowInfo("游戏信息增加成功", "GameKindItemList.aspx", 1200); } else { ShowInfo("游戏信息修改成功", "GameKindItemList.aspx", 1200); } } else { ShowError(msg.Content); } }