/// <summary>
/// 获取GameId的配置参数
/// </summary>
/// <param name="GameId">游戏Id</param>
/// <returns></returns>
public GameConfig GetGameConfig(int GameId)
{
GameConfig gc = null;
try
{
string sql = "select * from gameconfig where gameid=@GameId";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@GameId",GameId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
gc = new GameConfig((int)reder["id"], (int)reder["gameid"], reder["logincom"].ToString(), reder["paycom"].ToString(),
reder["existcom"].ToString(), reder["loginticket"].ToString(), reder["payticket"].ToString(),
reder["selectticket"].ToString(), reder["fcmticket"].ToString(), reder["agentid"].ToString());
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return gc;
}
/// <summary>
/// 添加游戏配置
/// </summary>
/// <param name="GameId">游戏Id</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddGameConfig(GameConfig gc)
{
try
{
string sql = "insert into GameConfig (logincom,paycom,existcom,loginticket,payticket,selectticket,fcmticket,agentid,gameid) values(@LoginCom,@PayCom,@ExistCom,@LoginTicket,@PayTicket,@SelectTicket,@FcmTicket,@AgentId,@GameId)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@LoginCom",gc.LoginCom),
new SqlParameter("@PayCom",gc.PayCom),
new SqlParameter("@ExistCom",gc.ExistCom),
new SqlParameter("@LoginTicket",gc.LoginTicket),
new SqlParameter("@PayTicket",gc.PayTicket),
new SqlParameter("@SelectTicket",gc.SelectTicket),
new SqlParameter("@FcmTicket",gc.FcmTicket),
new SqlParameter("@AgentId",gc.AgentId),
new SqlParameter("@GameId",gc.GameId)
};
return db.ExecuteNonQuery(sql, sp);
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 初始化接口参数
/// </summary>
public Game_Sjsg()
{
game = games.GetGame("sjsg"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Dpqk()
{
game = games.GetGame("dpqk"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
/// <summary>
/// 更新游戏配置
/// </summary>
/// <param name="GameId">游戏Id</param>
/// <returns>返回是否更新成功</returns>
public Boolean UpdateGameConfig(GameConfig gc)
{
return gcs.UpdateGameConfig(gc);
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Mxqy()
{
game = games.GetGame("mxqy"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Chcq()
{
game = games.GetGame("chcq"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
public ActionResult EditGame(int GameId)
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return RedirectToAction("Login", "Admin");
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 11231))
{
Games g = new Games();
g = gm.GetGame(GameId);
ViewData["GameId"] = GameId;
ViewData["GameNo"] = g.GameNo;
ViewData["GameName"] = g.Name;
ViewData["tjqf"] = g.tjqf;
string[] Str = g.GameProperty.Split('|');
ViewData["GameLx"] = Str[0];
ViewData["GameTz"] = Str[1];
ViewData["GameCzlx"] = Str[2];
ViewData["GameHm"] = Str[3];
ViewData["GameSfms"] = Str[4];
ViewData["IsRed"] = g.Is_Red == 1 ? true : false;
ViewData["IsHot"] = g.Is_Hot == 1 ? true : false;
ViewData["IsLock"] = g.Is_Lock == 1 ? true : false;
ViewData["SortId"] = g.Sort_Id;
ViewData["GameMoneyScale"] = g.GameMoneyScale;
ViewData["GameMoneyName"] = g.GameMoneyName;
ViewData["GameCom"] = g.GameCom;
ViewData["GameBBS"] = g.GameBBS;
ViewData["NewHand"] = g.NewHand;
ViewData["Pic1"] = g.Pic1;
ViewData["Pic2"] = g.Pic2;
ViewData["Pic3"] = g.Pic3;
ViewData["Pic4"] = g.Pic4;
ViewData["GameListImg"] = g.GameListImg;
ViewData["IndexTjImg"] = g.IndexTjImg;
ViewData["IndexHbImg"] = g.IndexHbImg;
ViewData["IndexHdImg"] = g.IndexHdImg;
ViewData["game_url_hd"] = g.game_url_hd;
ViewData["NewHand"] = g.NewHand;
ViewData["game_url_xzq"] = g.game_url_xzq;
ViewData["GameDesc"] = g.GameDesc;
GameConfig gc = new GameConfig();
gc = gcm.GetGameConfig(GameId);
if (gc != null)
{
ViewData["AgentId"] = gc.AgentId;
ViewData["LoginCom"] = gc.LoginCom;
ViewData["PayCom"] = gc.PayCom;
ViewData["ExistCom"] = gc.ExistCom;
ViewData["LoginTicket"] = gc.LoginTicket;
ViewData["PayTicket"] = gc.PayTicket;
ViewData["SelectTicket"] = gc.SelectTicket;
ViewData["FcmTicket"] = gc.FcmTicket;
}
ViewData["Function"] = "UpdateData('/Game/UpdateGame')";
return View("Game");
}
else
{
return RedirectToAction("Login", "Admin");
}
}
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化参数
/// </summary>
public Game_Qh()
{
game = games.GetGame("qh"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Djj()
{
game = games.GetGame("djj"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Sbcs()
{
game = games.GetGame("sbcs"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
/// <summary>
/// 更新游戏配置
/// </summary>
/// <param name="GameId">游戏Id</param>
/// <returns>返回是否更新成功</returns>
public Boolean UpdateGameConfig(GameConfig gc)
{
try
{
string sql = "update GameConfig set logincom=@LoginCom,paycom=@PayCom,existcom=@ExistCom,loginticket=@LoginTicket," +
"payticket=@PayTicket,selectticket=@SelectTicket,fcmticket=@FcmTicket,agentid=@AgentId"
+ " where gameid=@GameId ";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@LoginCom",gc.LoginCom),
new SqlParameter("@PayCom",gc.PayCom),
new SqlParameter("@ExistCom",gc.ExistCom),
new SqlParameter("@LoginTicket",gc.LoginTicket),
new SqlParameter("@PayTicket",gc.PayTicket),
new SqlParameter("@SelectTicket",gc.SelectTicket),
new SqlParameter("@FcmTicket",gc.FcmTicket),
new SqlParameter("@AgentId",gc.AgentId),
new SqlParameter("@GameId",gc.GameId)
};
return db.ExecuteNonQuery(sql, sp);
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 初始化参数
/// </summary>
public Game_Nslm()
{
game = games.GetGame("nslm"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Jlc()
{
game = games.GetGame("Jlc"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
public Game_Jhwj()
{
game = games.GetGame("jhwj"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 参数实例化
/// </summary>
public Game_Gjqx()
{
game = games.GetGame("gjqx"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Xyb()
{
game = games.GetGame("xyb"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 初始化接口参数
/// </summary>
public Game_Rxhzw()
{
game = games.GetGame("rxhzw"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 初始化接口参数
/// </summary>
public Game_Dxz()
{
game = games.GetGame("dxz"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Tgzt()
{
game = games.GetGame("tgzt"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
public Boolean UpdateGame()
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return false;
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 11231))
{
Games g = new Games();
g.Id = int.Parse(Request["GameId"]);
g.GameNo = Request["GameNo"];
g.Name = Request["GameName"];
g.tjqf = int.Parse(Request["tjqf"]);
g.GameProperty = Request["GameLx"] + "|" + Request["GameTz"] + "|" + Request["GameCzlx"] + "|" + Request["GameHm"] + "|" + Request["GameSfms"];
g.Is_Red = Request["IsRed"] == "on" ? 1 : 0;
g.Is_Hot = Request["IsHot"] == "on" ? 1 : 0;
g.Is_Lock = Request["IsLock"] == "on" ? 1 : 0;
g.Sort_Id = int.Parse(Request["SortId"]);
g.GameMoneyScale = int.Parse(Request["GameMoneyScale"]);
g.GameMoneyName = Request["GameMoneyName"];
g.GameCom = Request["GameCom"];
g.GameBBS = Request["GameBBS"];
g.NewHand = Request["NewHand"];
g.Pic1 = Request["Pic1"];
g.Pic2 = Request["Pic2"];
g.Pic3 = Request["Pic3"];
g.Pic4 = Request["Pic4"];
g.GameListImg = Request["GameListImg"];
g.IndexTjImg = Request["IndexTjImg"];
g.IndexHbImg = Request["IndexHbImg"];
g.IndexHdImg = Request["IndexHdImg"];
g.game_url_hd = Request["game_url_hd"];
g.game_url_xzq = Request["game_url_xzq"];
g.GameDesc = Request["GameDesc"];
GameConfig gc = new GameConfig();
gc.AgentId = Request["AgentId"];
gc.LoginCom = Request["LoginCom"];
gc.PayCom = Request["PayCom"];
gc.ExistCom = Request["ExistCom"];
gc.LoginTicket = Request["LoginTicket"];
gc.PayTicket = Request["PayTicket"];
gc.SelectTicket = Request["SelectTicket"];
gc.FcmTicket = Request["FcmTicket"];
gc.GameId = int.Parse(Request["GameId"]);
if (gcm.GetGameConfig(g.Id) == null)
{
return (gcm.AddGameConfig(gc) && gm.UpdateGame(g));
}
else
{
return (gcm.UpdateGameConfig(gc) && gm.UpdateGame(g));
}
}
else
{
return false;
}
}
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
public Game_Yxy()
{
game = games.GetGame("yxy"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Ftz()
{
game = games.GetGame("ftz"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Txj()
{
game = games.GetGame("txj"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
string tstamp; //定义时间戳
#endregion Fields
#region Constructors
/// <summary>
/// 实例化接口参数
/// </summary>
public Game_Xxas()
{
game = games.GetGame("xxas"); //获取游戏
gc = gcs.GetGameConfig(game.Id); //获取游戏参数
}
/// <summary>
/// 添加游戏配置
/// </summary>
/// <param name="GameId">游戏Id</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddGameConfig(GameConfig gc)
{
return gcs.AddGameConfig(gc);
}