public void ResetAvailableGrid(int iMatchID, int iTeamID, int iTeamPos, ref DataGridView dgv) { if (Common.g_DataBaseCon.State == System.Data.ConnectionState.Closed) { Common.g_DataBaseCon.Open(); } try { #region DML Command Setup for Get AvailbleTeamMember SqlCommand cmd = new SqlCommand("Proc_VB_EXT_GetTeamAvailable", Common.g_DataBaseCon); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter0 = new SqlParameter("@RegisterID", SqlDbType.Int); SqlParameter cmdParameter1 = new SqlParameter("@MatchID", SqlDbType.Int); SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3); SqlParameter cmdParameter3 = new SqlParameter("@TeamPos", SqlDbType.Int); cmdParameter0.Value = iTeamID; cmdParameter1.Value = iMatchID; cmdParameter2.Value = Common.g_strLanguage; cmdParameter3.Value = iTeamPos; cmd.Parameters.Add(cmdParameter0); cmd.Parameters.Add(cmdParameter1); cmd.Parameters.Add(cmdParameter2); cmd.Parameters.Add(cmdParameter3); #endregion SqlDataReader dr = cmd.ExecuteReader(); OVRDataBaseUtils.FillDataGridView(dgv, dr, null, null); if (dgv.RowCount >= 0) { dgv.Columns["F_MemberID"].Visible = false; dgv.Columns["F_FunctionID"].Visible = false; for (int i = 0; i < dgv.RowCount; i++) { int iDSQ = Common.Str2Int(dgv.Rows[i].Cells["DSQ"].Value); if (iDSQ == 1) { dgv.Rows[i].ReadOnly = true; dgv.Rows[i].DefaultCellStyle.BackColor = System.Drawing.Color.DarkGray; } } } dr.Close(); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }
public frmEntryOfficial(Int32 iMatchID, Int32 iMatchType) { InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventOfficials); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial); m_iMatchID = iMatchID; m_iMatchType = iMatchType; m_iMatchSplitID = -1; }
private void FillPositionComboBox() { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } try { #region DML Command Setup for Active Discipline string strDisciplineID = "0"; SqlCommand cmdDiscipline = new SqlCommand("Proc_GetActiveDiscipline", sqlConnection); cmdDiscipline.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmdDiscipline.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { strDisciplineID = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_DisciplineID"); } } dr.Close(); #endregion int nDisciplineID = Convert.ToInt32(strDisciplineID); #region DML Command Setup for Fill position combo SqlCommand cmd = new SqlCommand("Proc_GetPosition", sqlConnection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int); SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3); cmdParameter0.Value = nDisciplineID; cmdParameter1.Value = m_strLanguageCode; cmd.Parameters.Add(cmdParameter0); cmd.Parameters.Add(cmdParameter1); dr = cmd.ExecuteReader(); #endregion DataTable table = new DataTable(); table.Columns.Add("F_PositionLongName", typeof(string)); table.Columns.Add("F_PositionID", typeof(int)); table.Rows.Add("", "-1"); table.Load(dr); (dgvMember.Columns[4] as DGVCustomComboBoxColumn).FillComboBoxItems(table, "F_PositionLongName", "F_PositionID"); dr.Close(); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }
private void SetDgvSingleDiveList() { OVRDataBaseUtils.SetDataGridViewStyle(this.dgvSingleDiveList); dgvSingleDiveList.SelectionMode = DataGridViewSelectionMode.CellSelect; FontFamily fontFamily = new FontFamily("Arial"); FontStyle fontStyle = new FontStyle(); Font gridFont = new Font(fontFamily, 13, fontStyle); dgvSingleDiveList.Font = gridFont; }
public frmTeamPlayers(Int32 iMatchID, Int32 iMatchType, Int32 iPos) { InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamPlayers); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchPlayers); m_iMatchID = iMatchID; m_iMatchType = iMatchType; m_iPos = iPos; }
private void InitMatchById(Int32 iNodeType, Int32 iEventID, Int32 iPhaseID, Int32 iMatchID) { try { SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = m_DatabaseConnection; oneSqlCommand.CommandText = "Proc_GetMatchCompetitionRuleInfo"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter( "@NodeType", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, iNodeType); oneSqlCommand.Parameters.Add(cmdParameter1); SqlParameter cmdParameter2 = new SqlParameter( "@EventID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, iEventID); oneSqlCommand.Parameters.Add(cmdParameter2); SqlParameter cmdParameter3 = new SqlParameter( "@PhaseID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, iPhaseID); oneSqlCommand.Parameters.Add(cmdParameter3); SqlParameter cmdParameter4 = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, iMatchID); oneSqlCommand.Parameters.Add(cmdParameter4); if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed) { m_DatabaseConnection.Open(); } SqlDataReader sdr = oneSqlCommand.ExecuteReader(); if (sdr.HasRows) { if (sdr.Read()) { CmbCompetitionRule.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_CompetitionRuleID"); } } sdr.Close(); } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); } }
private void frmOVRWPPenaltyPlayer_Load(object sender, EventArgs e) { Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Home); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Visit); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Home); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Visit); ResetHomeGrid(); ResetVisitGrid(); }
private void InitMatchById(Int32 iMatchID, String strLanguageCode) { try { SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = m_DatabaseConnection; oneSqlCommand.CommandText = "Proc_GetMatchInfo"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, iMatchID); oneSqlCommand.Parameters.Add(cmdParameter1); SqlParameter cmdParameter2 = new SqlParameter( "@LanguageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, strLanguageCode); oneSqlCommand.Parameters.Add(cmdParameter2); if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed) { m_DatabaseConnection.Open(); } SqlDataReader sdr = oneSqlCommand.ExecuteReader(); if (sdr.HasRows) { if (sdr.Read()) { TextCode.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchCode"); TextOrder.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_Order"); TextMatchNum.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchNum"); textHasMedal.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchHasMedal"); TextLongName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchLongName"); TextShortName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchShortName"); TextComment.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchComment"); TextComment2.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchComment2"); TextCompetitorNum.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchCompetitorNum"); CmbStatus.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_MatchStatusID"); } } sdr.Close(); } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); } }
private void frmOfficialEntry_Load(object sender, EventArgs e) { Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailOfficial); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial); ResetAvailableOfficial(); ResetMatchOfficial(); InitPeriodCmb(); tbAttendance.Text = GVAR.g_ManageDB.GetMatchAttendance(m_iMatchID); }
public OVREventRecordsForm(int nEventID, SqlConnection dbConnection) { m_nEventID = nEventID; m_dbConnection = dbConnection; InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(dgvEventRecords); OVRDataBaseUtils.SetDataGridViewStyle(dgvRecordValue); OVRDataBaseUtils.SetDataGridViewStyle(dgvRecordMember); Localization(); }
public frmEntryOfficial(Int32 iMatchID, bool bIsTeam, ArrayList teamSplitIDs) { InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventOfficials); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial); m_bIsTeam = bIsTeam; m_iMatchID = iMatchID; m_teamSplitIDs = teamSplitIDs; }
private void SetDgvStyle() { OVRDataBaseUtils.SetDataGridViewStyle(this.dgvOuterMatchList); FontFamily fontFamily = new FontFamily("Arial"); FontStyle fontStyle = new FontStyle(); Font gridFont = new Font(fontFamily, 13, fontStyle); dgvOuterMatchList.Font = gridFont; OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchList); dgvMatchList.Font = gridFont; }
private void LoadData() { // Load Active Info OVRDataBaseUtils.GetActiveInfo(m_RegisterModule.DatabaseConnection, out m_iActiveSport, out m_iActiveDiscipline, out m_strActiveLanguage); m_iSportGroupType = GetGroupType(); //Register Tab RegisterInfoLoadData(); //Inscription Tab InscriptionLoadData(); }
private void ResetFederationList(int iDisciplineID, string strLanguageCode, int iGroupType) { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } try { #region DML Command Setup for Get Federation List SqlCommand cmd = new SqlCommand("Proc_GetGroupInfo", sqlConnection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter("@DisciplineID", SqlDbType.Int); SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3); SqlParameter cmdParameter3 = new SqlParameter("@GroupType", SqlDbType.Int); cmdParameter1.Value = iDisciplineID; cmdParameter2.Value = strLanguageCode; cmdParameter3.Value = iGroupType; cmd.Parameters.Add(cmdParameter1); cmd.Parameters.Add(cmdParameter2); cmd.Parameters.Add(cmdParameter3); #endregion SqlDataReader dr = cmd.ExecuteReader(); OVRDataBaseUtils.FillDataGridViewWithCmb(dgvFederation, dr, 0); dr.Close(); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } if (dgvFederation.Rows.Count > 0) { dgvFederation.ClearSelection(); for (int i = 0; i < m_arySelIndex.Count; i++) { int iSelIndex = (int)m_arySelIndex[i]; if (i == 0) { dgvFederation.FirstDisplayedScrollingRowIndex = iSelIndex; } dgvFederation.Rows[iSelIndex].Selected = true; } } }
private void frmGFCourse_Load(object sender, EventArgs e) { OVRDataBaseUtils.SetDataGridViewStyle(this.dgvCourseList); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvCourseDetail); Localization(); InitMatchInfo(); InitCourseInfo(); InitCmbRules(); cmbCourseList.SelectedValue = m_iCurMatchRuleID; }
private void frmOVRWPPenaltyScore_Load(object sender, EventArgs e) { Localization(); lbHomeName.Text = m_CCurMatch.m_CHomeTeam.TeamName; lbVisitName.Text = m_CCurMatch.m_CVisitTeam.TeamName; lbHGKName.Text = ""; lbVGKName.Text = ""; OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHomePenalty); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvVisitPenalty); FillPlayerUI(); }
private void frmTeamMemberEntry_Load(object sender, EventArgs e) { Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Home); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Visit); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Home); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Visit); ResetHomeGrid(); ResetVisitGrid(); InitUniformCmb(); }
public SetEventModelForm() { InitializeComponent(); Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvModels); m_iOpearateTypeID = 0; this.dgvModels.Enabled = false; this.btnImportEventModel.Enabled = false; this.btnExportEventModel.Enabled = false; this.btnDelEventModel.Enabled = false; this.RadioByParameter.Checked = true; }
private void ResetRegisterGrid() { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } try { #region DML Command Setup for Get AvailbleMember SqlCommand cmd = new SqlCommand("proc_GetAvailbleMember_With_Language", sqlConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.UpdatedRowSource = UpdateRowSource.None; SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int); SqlParameter cmdParameter1 = new SqlParameter("@GroupID", SqlDbType.NVarChar, 9); SqlParameter cmdParameter2 = new SqlParameter("@RegisterID", SqlDbType.Int); SqlParameter cmdParameter3 = new SqlParameter("@SexCode", SqlDbType.Int); SqlParameter cmdParameter4 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3); SqlParameter cmdParameter5 = new SqlParameter("@GroupType", SqlDbType.Int); m_strGroupID = cmbGroup.SelectedValue.ToString(); m_strSexCode = cmbSex.SelectedValue.ToString(); cmdParameter0.Value = Convert.ToInt32(m_strDisciplineID); cmdParameter1.Value = Convert.ToInt32(m_strGroupID); cmdParameter2.Value = Convert.ToInt32(m_strRegisterID); cmdParameter3.Value = Convert.ToInt32(m_strSexCode); cmdParameter4.Value = m_strLanguageCode; cmdParameter5.Value = m_iGroupType; cmd.Parameters.Add(cmdParameter0); cmd.Parameters.Add(cmdParameter1); cmd.Parameters.Add(cmdParameter2); cmd.Parameters.Add(cmdParameter3); cmd.Parameters.Add(cmdParameter4); cmd.Parameters.Add(cmdParameter5); #endregion SqlDataReader dr = cmd.ExecuteReader(); OVRDataBaseUtils.FillDataGridView(dgvAllRegister, dr, null, null); dr.Close(); SetGridStyle(dgvAllRegister); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }
public frmOVRSEDataEntry() { InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamA); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamB); //Hoop OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHoopResult); this.dgvHoopResult.SelectionMode = DataGridViewSelectionMode.CellSelect; m_processer = new QueueDataProcess<string>(this); m_processer.StartProcess(); }
public OVRCommunicationForm() { InitializeComponent(); m_oReportInfoOfc = new OVRReportInfo(); m_oReportInfoOnDuty = new OVRReportInfo(); m_oReportInfoOffDuty = new OVRReportInfo(); OVRDataBaseUtils.SetDataGridViewStyle(dgvReportForDuty); OVRDataBaseUtils.SetDataGridViewStyle(dgvCommunication); dgvReportForDuty.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvReportForDuty.ReadOnly = false; }
private void btnx_Status_Click(object sender, EventArgs e) { if (sender == btnx_StartList) { m_iCurStatusID = GFCommon.STATUS_STARTLIST; } else if (sender == btnx_Running) { m_iCurStatusID = GFCommon.STATUS_RUNNING; } else if (sender == btnx_Suspend) { m_iCurStatusID = GFCommon.STATUS_SUSPEND; } else if (sender == btnx_Unofficial) { m_iCurStatusID = GFCommon.STATUS_UNOFFICIAL; } else if (sender == btnx_Official) { m_iCurStatusID = GFCommon.STATUS_OFFICIAL; } else if (sender == btnx_Revision) { m_iCurStatusID = GFCommon.STATUS_REVISION; } else if (sender == btnx_Canceled) { m_iCurStatusID = GFCommon.STATUS_CANCELED; } if (sender == btnx_Unofficial) {//计算详细成绩排名信息 GFCommon.g_ManageDB.UpdateMatchResult(m_iCurMatchID, 1); GFCommon.g_ManageDB.UpdateTeamResult(m_iCurMatchID, 1); } Int32 iResultTeam = OVRDataBaseUtils.ChangeMatchStatus(m_iCurTeamMatchID, m_iCurStatusID, GFCommon.g_DataBaseCon, GFCommon.g_GFPlugin); Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_iCurMatchID, m_iCurStatusID, GFCommon.g_DataBaseCon, GFCommon.g_GFPlugin); if (iResult == 1) { UpdateMatchStatus(); } if (sender == btnx_Unofficial) {//计算小项奖牌信息 GFCommon.g_ManageDB.CalculateEventResult(m_iCurMatchID); } }
private string QueryDistrubutedVersion(string strTplType, string strRscCode) { string strDisVersion; strDisVersion = ""; strDisVersion = strTplType + strRscCode; try { SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = sqlConnection; oneSqlCommand.CommandText = "Proc_GetDistrubutedVersion"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter( "@TplType", SqlDbType.NVarChar, 20, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, strTplType); oneSqlCommand.Parameters.Add(cmdParameter1); SqlParameter cmdParameter2 = new SqlParameter( "@RscCode", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, strRscCode); oneSqlCommand.Parameters.Add(cmdParameter2); if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } SqlDataReader sdr = oneSqlCommand.ExecuteReader(); if (sdr.HasRows) { if (sdr.Read()) { strDisVersion = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_DistrubutedVersion"); } } sdr.Close(); } catch (Exception ex) { UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style); } return(strDisVersion); }
private void frmOVRGFDataEntry_Load(object sender, EventArgs e) { OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHolePar); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeam); SetDataGridViewStyle(this.dgvPlayer); Localization(); EnableControlButton(false, true); SetTCPInfo(); m_time = new System.Timers.Timer(3000); m_time.Elapsed += new System.Timers.ElapsedEventHandler(TimeElapsed); m_time.AutoReset = true; m_time.Enabled = true; }
public frmChosePhaseCompetitors(Int32 iEventID, Int32 iPhaseID, Int32 iNodeType, String strLanguageCode) { InitializeComponent(); Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventCompetitors); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvPhaseCompetitors); this.dgvEventCompetitors.RowHeadersVisible = true; this.dgvPhaseCompetitors.RowHeadersVisible = true; m_iEventID = iEventID; m_iPhaseID = iPhaseID; m_iNodeType = iNodeType; m_strLanguageCode = strLanguageCode; }
private void InitMatchInfo() { SqlConnection theDataBaseCon; theDataBaseCon = DVCommon.g_DataBaseCon; try { SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = theDataBaseCon; oneSqlCommand.CommandText = "Proc_DV_GetMatchInfo"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_iCurMatchID); oneSqlCommand.Parameters.Add(cmdParameter1); SqlParameter cmdParameter2 = new SqlParameter( "@LanguageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_strLanguageCode); oneSqlCommand.Parameters.Add(cmdParameter2); if (theDataBaseCon.State == System.Data.ConnectionState.Closed) { theDataBaseCon.Open(); } SqlDataReader sdr = oneSqlCommand.ExecuteReader(); if (sdr.HasRows) { if (sdr.Read()) { lb_MatchDes.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchDes"); m_iDisciplineID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_DisciplineID"); m_iCurMatchRuleID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_CompetitionRuleID"); } } sdr.Close(); } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); } }
private void FillInfoGrid() { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } try { #region DML Command Setup for NOC Info SqlCommand cmd = new SqlCommand("Proc_EQ_GetDesInfoList", sqlConnection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter0 = new SqlParameter("@DesTableName", SqlDbType.NVarChar, 50); SqlParameter cmdParameter1 = new SqlParameter("@DesName", SqlDbType.NVarChar, 50); SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3); cmdParameter0.Value = m_strDesTableName; cmd.Parameters.Add(cmdParameter0); cmdParameter1.Value = m_strDesName; cmd.Parameters.Add(cmdParameter1); cmdParameter2.Value = m_strLanguageCode; cmd.Parameters.Add(cmdParameter2); SqlDataReader dr = cmd.ExecuteReader(); #endregion OVRDataBaseUtils.FillDataGridView(dgvInfo, dr, null, null); dr.Close(); //隐藏ID列 dgvInfo.Columns[0].Visible = false; if (dgvInfo.Rows.Count > 0) { if (m_iSelRowIdx < 0) { return; } else if (m_iSelRowIdx > dgvInfo.RowCount - 1) { m_iSelRowIdx = dgvInfo.RowCount - 1; } dgvInfo.Rows[m_iSelRowIdx].Selected = true; dgvInfo.FirstDisplayedScrollingRowIndex = m_iSelRowIdx; } } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }
public bool UpdateUI(int matchID) { DataTable dt = BDCommon.g_ManageDB.GetViewScore(matchID); if (dt == null) { return(false); } OVRDataBaseUtils.FillDataGridView(dgViewScore, dt); dgViewScore.Columns[0].Width = 50; foreach (DataGridViewColumn col in dgViewScore.Columns) { col.SortMode = DataGridViewColumnSortMode.NotSortable; } lbMatchID.Text = matchID.ToString(); lbMatchCourt.Text = BDCommon.g_ManageDB.GetMatchCourtName(matchID); lbMatchRSC.Text = BDCommon.g_ManageDB.GetRscStringFromMatchID(matchID); String strSportDes, strPhaseDes, strDateDes, strVenueDes, strPlayNameA, strPlayNameB, strHomeScore, strAwayScore; int m_nCurPlayIDA, m_nCurPlayIDB, m_nCurStatusID, m_nRegAPos, m_nRegBPos; BDCommon.g_ManageDB.GetOneMatchDes(matchID, out m_nCurPlayIDA, out m_nCurPlayIDB, out strPlayNameA, out strPlayNameB, out m_nCurStatusID, out strSportDes, out strPhaseDes, out strDateDes, out strVenueDes, out strHomeScore, out strAwayScore, out m_nRegAPos, out m_nRegBPos); //lb_SportDes.Text = strSportDes; lbMatchTime.Text = strDateDes; this.Text = strPhaseDes; lbPlayerA.Text = strPlayNameA; lbPlayerB.Text = strPlayNameB; lbMatchScore.Text = BDCommon.g_ManageDB.GetMatchScoreString(matchID); bool bFound = false; for (int i = 0; i < lsbMatchID.Items.Count; i++) { if ((string)lsbMatchID.Items[i] == matchID.ToString()) { lsbMatchID.SelectedIndex = i; bFound = true; break; } } if (!bFound) { lsbMatchID.SelectedIndex = -1; } return(true); }
public HorseInscriptionForm(Int32 iEventID, Int32 iRegisterID, String strLanguageCode) { InitializeComponent(); Localization(); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailableHorses); OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHorseInscription); this.dgvAvailableHorses.RowHeadersVisible = true; this.dgvHorseInscription.RowHeadersVisible = true; dgvAvailableHorses.MultiSelect = false; dgvHorseInscription.MultiSelect = false; m_iEventID = iEventID; m_iRegisterID = iRegisterID; m_strLanguageCode = strLanguageCode; }
public frmImportMatchInfo(string strImportDir, XmlTypeEnum xmlType) { InitializeComponent(); OVRDataBaseUtils.SetDataGridViewStyle(dgMatchInfo); importDir_ = strImportDir; xmlType_ = xmlType; if (xmlType_ == XmlTypeEnum.XmlTypeMatchInfo) { btnImportAllAction.Visible = false; this.Text = "Import Match Result"; } else { this.Text = "Import Match Action"; } }