/// <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);
}
}
