コード例 #1
0
        public bool dgvMatchScoreRefresh(GameGeneralBall gameObj = null)
        {
            if (gameObj == null)
            {
                gameObj = Common.g_Game;
            }

            dgvMatchScore[2, 1].Value = gameObj.IsServeTeamB() ? "" : "●";
            dgvMatchScore[2, 2].Value = gameObj.IsServeTeamB() ? "●" : "";

            dgvMatchScore[3, 1].Value = gameObj.GetScoreSetStr(false, 1);
            dgvMatchScore[3, 2].Value = gameObj.GetScoreSetStr(true, 1);
            dgvMatchScore[4, 1].Value = gameObj.GetScoreSetStr(false, 2);
            dgvMatchScore[4, 2].Value = gameObj.GetScoreSetStr(true, 2);
            dgvMatchScore[5, 1].Value = gameObj.GetScoreSetStr(false, 3);
            dgvMatchScore[5, 2].Value = gameObj.GetScoreSetStr(true, 3);
            dgvMatchScore[6, 1].Value = gameObj.GetScoreSetStr(false, 4);
            dgvMatchScore[6, 2].Value = gameObj.GetScoreSetStr(true, 4);
            dgvMatchScore[7, 1].Value = gameObj.GetScoreSetStr(false, 5);
            dgvMatchScore[7, 2].Value = gameObj.GetScoreSetStr(true, 5);
            dgvMatchScore[8, 1].Value = gameObj.GetScoreMatchStr(false);
            dgvMatchScore[8, 2].Value = gameObj.GetScoreMatchStr(true);

            dgvMatchScore[3, 1].Style.ForeColor = gameObj.GetWinSet(1) == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[3, 2].Style.ForeColor = gameObj.GetWinSet(1) == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[4, 1].Style.ForeColor = gameObj.GetWinSet(2) == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[4, 2].Style.ForeColor = gameObj.GetWinSet(2) == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[5, 1].Style.ForeColor = gameObj.GetWinSet(3) == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[5, 2].Style.ForeColor = gameObj.GetWinSet(3) == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[6, 1].Style.ForeColor = gameObj.GetWinSet(4) == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[6, 2].Style.ForeColor = gameObj.GetWinSet(4) == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[7, 1].Style.ForeColor = gameObj.GetWinSet(5) == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[7, 2].Style.ForeColor = gameObj.GetWinSet(5) == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[8, 1].Style.ForeColor = gameObj.GetWinMatch() == EGbTeam.emTeamA ? ClrScr_Win : ClrScr_Nor;
            dgvMatchScore[8, 2].Style.ForeColor = gameObj.GetWinMatch() == EGbTeam.emTeamB ? ClrScr_Win : ClrScr_Nor;

            dgvMatchScore[3, 3].Value = gameObj.GetTimeSetStr(1);
            dgvMatchScore[4, 3].Value = gameObj.GetTimeSetStr(2);
            dgvMatchScore[5, 3].Value = gameObj.GetTimeSetStr(3);
            dgvMatchScore[6, 3].Value = gameObj.GetTimeSetStr(4);
            dgvMatchScore[7, 3].Value = gameObj.GetTimeSetStr(5);
            dgvMatchScore[8, 3].Value = gameObj.GetTimeMatchStr();

            Int32 nCurSet = gameObj.GetCurSet();

            dgvMatchScore[3, 0].Value = (nCurSet == 1) ? "●" : "";
            dgvMatchScore[4, 0].Value = (nCurSet == 2) ? "●" : "";
            dgvMatchScore[5, 0].Value = (nCurSet == 3) ? "●" : "";
            dgvMatchScore[6, 0].Value = (nCurSet == 4) ? "●" : "";
            dgvMatchScore[7, 0].Value = (nCurSet == 5) ? "●" : "";

            DataTable tblMatchInfo = Common.dbGetMatchInfo(Common.g_nMatchID, Common.g_strLanguage);

            if (tblMatchInfo != null)
            {
                dgvMatchScore[1, 1].Value = tblMatchInfo.Rows[0]["F_IRMCodeA"].ToString();
                dgvMatchScore[1, 2].Value = tblMatchInfo.Rows[0]["F_IRMCodeB"].ToString();
            }

            dgvMatchScore[8, 0].Value = gameObj.GetPointInfo().GetCountStr() + ' ' + gameObj.GetPointInfo().GetPointStr();

            return(true);
        }
コード例 #2
0
        public static bool dbGameObj2Db(Int32 nMatchID, GameGeneralBall gameObj)
        {
            if (nMatchID <= 0)
            {
                Debug.Assert(false);
                return(false);
            }

            StringBuilder strWin       = new StringBuilder();
            StringBuilder strTime      = new StringBuilder();
            StringBuilder strPoint     = new StringBuilder();
            StringBuilder strScoreIntA = new StringBuilder();
            StringBuilder strScoreIntB = new StringBuilder();
            StringBuilder strScoreStrA = new StringBuilder();
            StringBuilder strScoreStrB = new StringBuilder();

            //先往字符串里装入总的信息
            Int32   nWin  = 0;
            EGbTeam eTeam = gameObj.GetWinMatch();

            if (eTeam == EGbTeam.emTeamA)
            {
                nWin = 1;
            }
            else
            if (eTeam == EGbTeam.emTeamB)
            {
                nWin = 2;
            }
            else
            {
                nWin = 0;
            }

            strWin.Append(nWin);
            strTime.Append(gameObj.GetTimeMatch() / 1000 / 60);

            //获取Point信息
            {
                SGbPointInfo ePoint = gameObj.GetPointInfo();


                if (ePoint.m_ePoint == EGbPointInfo.emPointSet)
                {
                    strPoint.Append("1,");
                }
                else if (ePoint.m_ePoint == EGbPointInfo.emPointGame || ePoint.m_ePoint == EGbPointInfo.emPointMatch)
                {
                    strPoint.Append("2,");
                }
                else
                {
                    strPoint.Append("0,");
                }

                if (ePoint.m_eTeam == EGbTeam.emTeamA)
                {
                    strPoint.Append("1,");
                }
                else if (ePoint.m_eTeam == EGbTeam.emTeamB)
                {
                    strPoint.Append("2,");
                }
                else
                {
                    strPoint.Append("0,");
                }

                strPoint.Append(ePoint.m_byCount.ToString());
                strPoint.Append(",");
            }

            strScoreIntA.Append(gameObj.GetScoreMatch(false));
            strScoreIntB.Append(gameObj.GetScoreMatch(true));
            strScoreStrA.Append(gameObj.GetScoreMatchStr(false));
            strScoreStrB.Append(gameObj.GetScoreMatchStr(true));
            strWin.Append(',');
            strTime.Append(',');
            strScoreIntA.Append(',');
            strScoreIntB.Append(',');
            strScoreStrA.Append(',');
            strScoreStrB.Append(',');

            //再循环装入每局信息
            for (int nCycSet = 1; nCycSet < GameGeneralBall.MAX_SET; nCycSet++)
            {
                Int32   nSetWin  = 0;
                EGbTeam eSetTeam = gameObj.GetWinSet(nCycSet);
                if (eSetTeam == EGbTeam.emTeamA)
                {
                    nSetWin = 1;
                }
                else
                if (eSetTeam == EGbTeam.emTeamB)
                {
                    nSetWin = 2;
                }
                else
                {
                    nSetWin = 0;
                }

                strWin.Append(nSetWin);
                strTime.Append(gameObj.GetTimeSet(nCycSet) / 1000 / 60);
                strScoreIntA.Append(gameObj.GetScoreSet(false, nCycSet));
                strScoreIntB.Append(gameObj.GetScoreSet(true, nCycSet));
                strScoreStrA.Append(gameObj.GetScoreSetStr(false, nCycSet));
                strScoreStrB.Append(gameObj.GetScoreSetStr(true, nCycSet));
                strWin.Append(',');
                strTime.Append(',');
                strScoreIntA.Append(',');
                strScoreIntB.Append(',');
                strScoreStrA.Append(',');
                strScoreStrB.Append(',');
            }

            SqlCommand dbCmd = new SqlCommand("proc_VB_PRG_MatchSetScore", g_DataBaseCon);

            dbCmd.CommandType = CommandType.StoredProcedure;

            dbCmd.Parameters.AddWithValue("@MatchID", nMatchID);
            dbCmd.Parameters.AddWithValue("@SetCount", 5);
            dbCmd.Parameters.AddWithValue("@CurSet", gameObj.GetCurSet());
            dbCmd.Parameters.AddWithValue("@ServeTeamB", gameObj.IsServeTeamB() ? 1 : 0);
            dbCmd.Parameters.AddWithValue("@PointInfo", strPoint.ToString());
            dbCmd.Parameters.AddWithValue("@SetWinList", strWin.ToString());
            dbCmd.Parameters.AddWithValue("@SetTimeList", strTime.ToString());
            dbCmd.Parameters.AddWithValue("@SetScoreListA", strScoreIntA.ToString());
            dbCmd.Parameters.AddWithValue("@SetScoreListB", strScoreIntB.ToString());
            dbCmd.Parameters.AddWithValue("@SetScoreListStrA", strScoreStrA.ToString());
            dbCmd.Parameters.AddWithValue("@SetScoreListStrB", strScoreStrB.ToString());
            dbCmd.Parameters.AddWithValue("@Result", DBNull.Value);
            dbCmd.Parameters["@Result"].Size      = 4;
            dbCmd.Parameters["@Result"].SqlDbType = SqlDbType.Int;
            dbCmd.Parameters["@Result"].Direction = ParameterDirection.Output;

            if (!dbExecuteNonQuery(ref dbCmd))
            {
                MessageBox.Show("proc_VB_PRG_MatchSetScore exec failed!");
                return(false);
            }

            if ((int)dbCmd.Parameters["@Result"].Value <= 0)
            {
                MessageBox.Show("proc_VB_PRG_MatchSetScore return failed!");
                return(false);
            }

            return(true);
        }