public ActionResult Create()
{
GameBLL defGame = new GameBLL();
defGame.GameID = 0;
return(View(defGame));
}
public DetailWindow(GameBLL gameBLL, int id)
{
_gameBLL = gameBLL;
_game = _gameBLL.GetById(id, out string error_message);
InitializeComponent();
this.DataContext = _gameBLL;
cmb_Rating.ItemsSource = GameRatingList.RatingList;
}
public DetailWindow(GameBLL gameBLL)
{
_gameBLL = gameBLL;
_game = new Game();
InitializeComponent();
this.DataContext = _gameBLL;
cmb_Rating.ItemsSource = GameRatingList.RatingList;
}
public MainWindow()
{
gameRepository = new AzureDBGameRepository();
gameBLL = new GameBLL(gameRepository);
InitializeComponent();
this.DataContext = gameBLL;
cmb_Rating.ItemsSource = GameRatingList.RatingList;
}
/// 游戏类别绑定
/// </summary>
/// </summary>
public void getYx() {
DataSet ds = new DataSet();
ds = GameBLL.GetGameLxBLL();
DataRow row = ds.Tables[0].NewRow();
row[0] = -1;
row[1] = "全部";
ds.Tables[0].Rows.InsertAt(row, 0);
cmbyxlx.DataSource = ds.Tables[0];
cmbyxlx.ValueMember = "gid";
cmbyxlx.DisplayMember = "gname";
}
protected void Page_Load(object sender, EventArgs e)
{
string sUserName = CYRequest.GetString("username");
string sPWD = CYRequest.GetString("pwd");
string sKey = CYRequest.GetString("key");
string sGameID = CYRequest.GetString("gameid");
string sServerid = CYRequest.GetString("serverid");
if (ValKey(sUserName, sPWD, sKey))
{
string sState = UserBll.UserVal(sUserName, sPWD);
if ("0" == sState)
{
int iUserID = UserBll.UserIDSel(sUserName);
string sbbsKey = ConfigurationManager.AppSettings["UserValKey"].ToString();
string sUrl = DiscuzUserI.BBSLogin(sUserName, sPWD, sbbsKey);
string sPageUrl = Request.Url.ToString();
LoginStateSet(sUserName, iUserID, sPageUrl);
int iGameID = 0;
int.TryParse(sGameID, out iGameID);
int iServerID = 0;
int.TryParse(sServerid, out iServerID);
string sGameAbbre = GameBLL.GameAbbreSel(iGameID, iServerID).Trim();
string sGame = GameInfoBLL.GameInfoAbbreSel(sGameAbbre).TrimEnd();
string sGameUrl = string.Empty;
switch (sGame)
{
case "sssg":
string client = CYRequest.GetString("client");
sGameUrl = string.Format("{0}/GCenter/PlayGame.aspx?gn={1}&client={2}", sRootUrl, sGameAbbre, client);
break;
case "tssg":
string fuid = CYRequest.GetString("fuid");
sGameUrl = string.Format("{0}/GCenter/PlayGame.aspx?gn={1}&fuid={2}", sRootUrl, sGameAbbre, fuid);
break;
default:
sGameUrl = string.Format("{0}/GCenter/PlayGame.aspx?gn={1}", sRootUrl, sGameAbbre);
break;
}
sMsg = string.Format("<script>location.href='{0}'</script><script src='{1}'></script>", sGameUrl, sUrl);
}
else
{
sMsg = string.Format("<script>alert('用户信息输入错误，验证失败！')</script><script>location.href='{0}/Default.aspx'</script>", sRootUrl);
return;
}
}
else
{
Response.Redirect("../Default.aspx", true);
}
}
private void btnmc_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
ds = GameBLL.BlurryBLL(txtmc.Text.Trim());
dgvshow.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Guid?QueueForGame(Guid playerId)
{
var gameId = Queue.QueueForGame(playerId);
// if game is found but is not started yet, start a game
if (gameId != null)
{
if (!ActiveGames.ContainsKey(gameId.Value))
{
var players = Queue.GetPlayerForGame(gameId.Value);
GameBLL.StartGame(gameId.Value, players[0], players[1]);
ActiveGames[gameId.Value] = new BoardGameState <TFigure>(gameId.Value, players[0], new TRules());
}
}
return(gameId);
}
public void getShow() {
try
{
DataSet ds = new DataSet();
ds = GameBLL.GetShowLxDAL(Convert.ToInt32(this.cmblx.SelectedValue));
dgvshow.DataSource = ds.Tables[0].DefaultView;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string agentid = CYRequest.GetString("agentid");
string sign = CYRequest.GetString("sign");//md5(agentid + TICKEY)
string TICKEY = "dao50GSel_ko(*dg_)12:?do";
StringBuilder sbText = new StringBuilder(50);
sbText.Append(agentid);
sbText.Append(TICKEY);
string sValSign = ProvideCommon.MD5(sbText.ToString());
if (sign == sValSign)
{
Response.Write(GameBLL.GameDBXml());
}
else
{
Response.Write("-1");
}
}
//List<SelectListItem> GetRoleItems()
//{
// List<SelectListItem> ProposedReturnValue = new List<SelectListItem>();
// using (ContextBLL ctx = new ContextBLL())
// {
// List<RoleBLL> roles = ctx.GetRoles(0, 25);
// foreach (RoleBLL role in roles)
// {
// SelectListItem item = new SelectListItem();
// item.Value = role.RoleID.ToString();
// item.Text = role.RoleName;
// ProposedReturnValue.Add(item);
// }
// }
// return ProposedReturnValue;
//}
// GET: RegisterUser/Create
public ActionResult Register()
{
RegistrationModel Model = new RegistrationModel();
using (ContextBLL ctx = new ContextBLL())
{
ViewBag.Games = GetGameItems(ctx);
UserBLL defGame = new UserBLL();
defGame.UserID = 0;
CommentBLL defComment = new CommentBLL();
defComment.CommentID = 0;
GameBLL thisGame = new GameBLL();
//GameBLL game = ctx.FindGameByGameID(id);
thisGame.GameID = 0;
//CommentBLL comment = ctx.FindCommentByCommentID(id);
//List<CommentBLL> comment = ctx.GetComments(skip, take);
//return View(Model);
}
return(View(Model));
}
public void TestWord()
{
//checking if the word is retrived
GameBLL bll = new GameBLL();
bool actualResult, expectedResult;
bll._wordSet = "a";
DataTable dtCheck = bll.RetriveWords();
expectedResult = true;
if (dtCheck.Rows.Count > 0)
{
actualResult = true;
}
else
{
actualResult = false;
}
Assert.AreEqual(actualResult, expectedResult);
}
public BoardGameMoveResult <TFigure> MakeMove(Guid gameId, Guid playerId, string from, string to)
{
var game = ActiveGames[gameId];
var rules = new TRules();
var moveResult = rules.MakeMove(game, from, to);
var players = Queue.GetPlayerForGame(gameId);
var otherPlayer = players.Where(x => x != playerId).First();
if (moveResult.Ok)
{
moveResult.State.CurrentPlayer = otherPlayer;
GameMoveBLL.AddMove(gameId, playerId, from, to);
moveResult.State.Winner = rules.GetWinner(moveResult.State, players[0], players[1]);
if (moveResult.State.Winner != null)
{
GameBLL.EndGame(gameId, moveResult.State.Winner.Value);
Queue.DequeuePlayers(players[0], players[1]);
}
}
return(moveResult);
}
private void btndelete_Click(object sender, EventArgs e)
{
if (dgvshow.SelectedCells.Count==0)
{
return;
}
if (DialogResult.Yes== MessageBox.Show("你确定要删除吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
int pid = Convert.ToInt32(txtpid.Text.Trim());
if (GameBLL.DeleteBLL(pid)>0)
{
MessageBox.Show("删除成功");
getShow();
}
else
{
MessageBox.Show("删除失败");
}
}
}
private void btnxg_Click(object sender, EventArgs e)
{
try
{
Gaming ga = new Gaming();
ga.Pgs = txtgs.Text.Trim();
ga.Pname = txtname.Text.Trim();
ga.Pje = Convert.ToInt32(txtqian.Text.Trim());
ga.Gid = Convert.ToInt32(cmbyxlx.SelectedValue);
ga.Pid = Convert.ToInt32(txtpid.Text.Trim());
GameBLL.AddBLL(ga);
getShow();
MessageBox.Show("修改成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected string HelpClassLJSel(int iGameID, string sClassName)
{
return(GameBLL.GameHelpLJJsonSelFromCMS(iGameID, sClassName));
}
protected string HelpClassLJ2DLGGSel(string sClassID)
{
return(GameBLL.GameHelpLJ2DDGGSel(sClassID));
}
public void ProcessRequest(HttpContext context)
{
LoginUser loginUser = new LoginUser(context, "WinPrizeReport");
LotteryOrderBLL bll = new LotteryOrderBLL(context, loginUser);
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
string city = context.Request["cityId"];
string county = context.Request["countyId"];
string siteId = context.Request["siteId"];
string terminalId = context.Request["terminalId"];
string lotteryType = context.Request["lotteryType"];
string gameId = context.Request["gameId"];
bll.WinPrizeDataLoadGrid(page, rows, startDate, endDate, city, county, siteId, terminalId, lotteryType, gameId);
}
if (context.Request["action"] == "totalFee")
{
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
string city = context.Request["cityId"];
string county = context.Request["countyId"];
string siteId = context.Request["siteId"];
string terminalId = context.Request["terminalId"];
string lotteryType = context.Request["lotteryType"];
string gameId = context.Request["gameId"];
context.Response.Write(bll.GetTotalWinPrize(startDate, endDate, city, county, siteId, terminalId, lotteryType, gameId));
}
//加载市
if (context.Request["action"] == "cityListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.CityCombobox();
}
//加载区县
if (context.Request["action"] == "countyListLoad")
{
string cityId = context.Request["cityId"];
Combobox com = new Combobox(context, loginUser);
com.CountyCombobox(cityId);
}
//加载执法文书类型
if (context.Request["action"] == "siteListLoad")
{
Combobox com = new Combobox(context, loginUser);
string cityId = context.Request["cityId"];
string countyId = context.Request["countyId"];
com.SiteByAreaCombobox(cityId, countyId);
}
//加载彩种
if (context.Request["action"] == "lotteryTypeListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.LotteryTypeCombobox();
}
//加载游戏
if (context.Request["action"] == "gameListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.GameCombobox();
}
if (context.Request["action"] == "ToExcel")
{
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
string city = context.Request["cityId"];
string county = context.Request["countyId"];
string siteId = context.Request["siteId"];
string terminalId = context.Request["terminalId"];
string lotteryType = context.Request["lotteryType"];
string gameId = context.Request["gameId"];
DataTable dt = bll.WinPrizeDataReport(startDate, endDate, city, county, siteId, terminalId, lotteryType, gameId);
object sumObject = dt.Compute("sum(awardmoney)", "TRUE");
context.Response.ContentType = "application/x-excel";
string fileName = HttpUtility.UrlEncode(startDate + "至" + endDate + "中奖数据报表.xls");
context.Response.AddHeader("Content-Disposition", "attachment; fileName=" + fileName);
IWorkbook workbook = new HSSFWorkbook();
//创建表
ISheet sheet = workbook.CreateSheet("中奖数据报表");
//设置单元的宽度
sheet.SetColumnWidth(0, 10 * 256);
sheet.SetColumnWidth(1, 10 * 256);
sheet.SetColumnWidth(2, 15 * 256);
sheet.SetColumnWidth(3, 10 * 256);
sheet.SetColumnWidth(4, 13 * 256);
sheet.SetColumnWidth(5, 10 * 256);
sheet.SetColumnWidth(6, 10 * 256);
sheet.SetColumnWidth(7, 13 * 256);
sheet.SetColumnWidth(8, 20 * 256);
sheet.SetColumnWidth(9, 30 * 256);
sheet.SetColumnWidth(10, 15 * 256);
#region 合并单元格
CellRangeAddress regionTitle = new CellRangeAddress(0, 0, 0, 10);
sheet.AddMergedRegion(regionTitle);
CellRangeAddress regionDate = new CellRangeAddress(1, 1, 0, 10);
sheet.AddMergedRegion(regionDate);
CellRangeAddress regionSearch = new CellRangeAddress(2, 2, 0, 10);
sheet.AddMergedRegion(regionSearch);
//CellRangeAddress（）该方法的参数次序是：开始行号，结束行号，开始列号，结束列号。
IRow row0 = sheet.CreateRow(0);
row0.Height = 20 * 20;
ICell icell1top0 = row0.CreateCell(0);
icell1top0.SetCellValue("中奖数据报表");
NOPIHelper.RegionMethod(workbook, sheet, regionTitle, NOPIHelper.Stylexls.标题);
IRow row1 = sheet.CreateRow(1);
row1.Height = 20 * 20;
ICell icell1top1 = row1.CreateCell(0);
icell1top1.SetCellValue("日期:" + startDate + "至" + endDate + " 中奖总额:" + double.Parse(sumObject == DBNull.Value ? "0" : sumObject.ToString()).ToString("￥#,##0.00") + "");
NOPIHelper.RegionMethod(workbook, sheet, regionDate, NOPIHelper.Stylexls.头);
IRow row2 = sheet.CreateRow(2);
row2.Height = 20 * 20;
ICell icell1top2 = row2.CreateCell(0);
var cityName = "";
var countyName = "";
var siteName = "";
var lotteryName = "";
var gameName = "";
SiteBLL siteBLL = new SiteBLL(context, loginUser);
AreaBLL areaBLL = new AreaBLL(context, loginUser);
LotteryBLL lotteryBLL = new LotteryBLL(context, loginUser);
GameBLL gameBLL = new GameBLL(context, loginUser);
if (!string.IsNullOrEmpty(siteId))
{
siteName = siteBLL.Get(siteId).siteName;
}
if (!string.IsNullOrEmpty(city))
{
cityName = areaBLL.Get(city).areaName;
}
if (!string.IsNullOrEmpty(county))
{
countyName = areaBLL.Get(county).areaName;
}
if (!string.IsNullOrEmpty(lotteryType))
{
lotteryName = lotteryBLL.Get(lotteryType).LotteryTypeName;
}
if (!string.IsNullOrEmpty(gameId))
{
gameName = gameBLL.Get(gameId).gameName;
}
icell1top2.SetCellValue("市:" + cityName + " 区县:" + countyName + " 执法文书类型:" + siteName + " 终端号:" + terminalId + " 彩种:" + lotteryName + " 游戏:" + gameName + "");//搜索条件
NOPIHelper.RegionMethod(workbook, sheet, regionSearch, NOPIHelper.Stylexls.头);
#endregion
#region 设置表头
int rowsNum = 3; //行号
IRow row3 = sheet.CreateRow(rowsNum);
row3.Height = 20 * 20;
ICell icell1top = row3.CreateCell(0);
icell1top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell1top.SetCellValue("市");
ICell icell2top = row3.CreateCell(1);
icell2top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell2top.SetCellValue("区(县)");
ICell icell3top = row3.CreateCell(2);
icell3top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell3top.SetCellValue("执法文书类型名称");
ICell icell4top = row3.CreateCell(3);
icell4top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell4top.SetCellValue("终端号");
ICell icell5top = row3.CreateCell(4);
icell5top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell5top.SetCellValue("客户编号");
ICell icell6top = row3.CreateCell(5);
icell6top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell6top.SetCellValue("彩种");
ICell icell7top = row3.CreateCell(6);
icell7top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell7top.SetCellValue("游戏");
ICell icell8top = row3.CreateCell(7);
icell8top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell8top.SetCellValue("期次");
ICell icell9top = row3.CreateCell(8);
icell9top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell9top.SetCellValue("交易时间");
ICell icell10top = row3.CreateCell(9);
icell10top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell10top.SetCellValue("订单号");
ICell icell11top = row3.CreateCell(10);
icell11top.CellStyle = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.头);
icell11top.SetCellValue("中奖金额");
#endregion
rowsNum = 4; //行号
ICellStyle cellStyleMoney = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.钱);
ICellStyle cellStyleTime = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.时间);
ICellStyle cellStyleDefault = NOPIHelper.Getcellstyle(workbook, NOPIHelper.Stylexls.默认);
foreach (DataRow dr in dt.Rows)
{
/******************写入字段值*********************/
row3 = sheet.CreateRow(rowsNum);
ICell icel1City = row3.CreateCell(0);
icel1City.SetCellValue(dr["city"].ToString());
icel1City.CellStyle = cellStyleDefault;
ICell icellCounty = row3.CreateCell(1);
icellCounty.SetCellValue(dr["county"].ToString());
icellCounty.CellStyle = cellStyleDefault;
ICell icellSiteName = row3.CreateCell(2);
icellSiteName.SetCellValue(dr["siteName"].ToString());
icellSiteName.CellStyle = cellStyleDefault;
ICell icel1TerminalId = row3.CreateCell(3);
icel1TerminalId.SetCellValue(dr["terminalId"].ToString());
icel1TerminalId.CellStyle = cellStyleDefault;
ICell icel1ClientId = row3.CreateCell(4);
icel1ClientId.SetCellValue(dr["clientId"].ToString());
icel1ClientId.CellStyle = cellStyleDefault;
ICell icel1LotteryType = row3.CreateCell(5);
icel1LotteryType.SetCellValue(dr["lotteryType"].ToString());
icel1LotteryType.CellStyle = cellStyleDefault;
ICell icel1GameId = row3.CreateCell(6);
icel1GameId.SetCellValue(dr["gameId"].ToString());
icel1GameId.CellStyle = cellStyleDefault;
ICell icel1Period = row3.CreateCell(7);
icel1Period.SetCellValue(dr["period"].ToString());
icel1Period.CellStyle = cellStyleDefault;
ICell icel1AwardTime = row3.CreateCell(8);
icel1AwardTime.SetCellValue(dr["awardtime"].ToString());
icel1AwardTime.CellStyle = cellStyleTime;
ICell icel1OrderId = row3.CreateCell(9);
icel1OrderId.SetCellValue(dr["orderid"].ToString());
icel1OrderId.CellStyle = cellStyleDefault;
ICell icel1AwardMoney = row3.CreateCell(10);
icel1AwardMoney.SetCellValue(double.Parse(dr["awardmoney"].ToString()));
icel1AwardMoney.CellStyle = cellStyleMoney;
rowsNum++;
}
workbook.Write(context.Response.OutputStream); //输出到流中
}
}
