private void FillOuterMatchList()
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = _OuterDBConnection;
string strSQL;
strSQL = ConfigurationManager.GetPluginSettingString("DV", "SQL_MatchList");
if (strSQL.Length == 0)
{
strSQL = @"SELECT EventNameI, EventID FROM dvEvent";
ConfigurationManager.SetPluginSettingString("DV", "SQL_MatchList", strSQL);
}
oneSqlCommand.CommandText = strSQL;
oneSqlCommand.CommandType = CommandType.Text;
if (_OuterDBConnection.State == System.Data.ConnectionState.Closed)
{
_OuterDBConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvOuterMatchList, sdr);
sdr.Close();
dgvOuterMatchList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void ResetAllVenuesGrid(String strLanguageCode)
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get All Venues
String strSQL;
strSQL = String.Format(@"SELECt F_VenueLongName AS [Venue LongName], F_VenueShortName AS [Venue ShortName], F_VenueID AS [ID] FROM TC_Venue_Des
WHERE F_LanguageCode = '{0}'", strLanguageCode);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvAllVenues, dr, null, null);
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void UpdateUIFromOtherThread(TransmitStatus status, TSMatchInfo matchInfo)
{
if (status == TransmitStatus.StartList || status == TransmitStatus.RankList)
{
lbHeight.Text = matchInfo.StartInfo.Height;
lbStartBib.Text = matchInfo.StartInfo.BibNumber;
lbStartDiff.Text = matchInfo.StartInfo.Difficulty;
lbStartDiveCode.Text = matchInfo.StartInfo.DiveCode;
lbStartName.Text = matchInfo.StartInfo.PlayerName;
lbStartRound.Text = matchInfo.StartInfo.RoundNumber;
lbStartNO.Text = matchInfo.StartInfo.StartNumber;
lbStartNOC.Text = matchInfo.StartInfo.NOC;
lbStartPoints.Text = matchInfo.StartInfo.Points;
lbStartRank.Text = matchInfo.StartInfo.Rank;
}
else if (status == TransmitStatus.Score)
{
OVRDataBaseUtils.FillDataGridView(dgJudgeScore, matchInfo.ScoreInfo);
dgJudgeScore.ClearSelection();
}
if (status == TransmitStatus.RankList)
{
OVRDataBaseUtils.FillDataGridView(dgRankList, matchInfo.RankInfo);
dgRankList.ClearSelection();
}
TSDlg_OnTSUpdateDB();
}
private void ResetDisciplineVenueGrid(int iDisciplineID, String strLanguageCode)
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Discipline Venues
String strSQL;
strSQL = String.Format(@"SELECT B.F_VenueLongName AS [Venue LongName], B.F_VenueShortName AS [Venue ShortName], A.F_VenueID, A.F_DisciplineID
FROM TD_Discipline_Venue AS A LEFT JOIN TC_Venue_Des AS B ON A.F_VenueID = B.F_VenueID
WHERE B.F_LanguageCode = '{0}' AND A.F_DisciplineID = {1}" , strLanguageCode, iDisciplineID);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvDisciplineVenue, dr, null, null);
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void GetHorses()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get AvailbleMember
SqlCommand cmd = new SqlCommand("Proc_EQ_GetRegisterAvailableHorses", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@RegisterID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = m_iRegisterID;
cmdParameter1.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvAvailableHorses, dr, null, null);
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void UpdateGridView(DataGridView dgv, SqlDataReader sdr)
{
m_bUpdatingUI = true;
Int32 iCurSel = -1;
if (dgv.SelectedRows.Count != 0)
{
iCurSel = dgv.SelectedRows[0].Index;
}
OVRDataBaseUtils.FillDataGridView(dgv, sdr, null, null);
if (dgv.Columns["ID"] != null)
{
dgv.Columns["ID"].Visible = false;
}
while (iCurSel >= dgv.Rows.Count)
{
iCurSel--;
}
if (iCurSel != -1)
{
dgv.Rows[iCurSel].Selected = true;
dgv.FirstDisplayedScrollingRowIndex = iCurSel;
}
m_bUpdatingUI = false;
}
private void UpdateGridView()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Discipline Venues
String strSQL;
strSQL = String.Format(@"SELECT F_NewsID AS [ID], F_NewsItem AS [Item], F_SubTitle AS [SubTitle], F_Heading AS [Heading], F_Issued_by AS [IssuedBy], F_Date AS [Date]
FROM TS_Offical_Communication
WHERE F_DisciplineID = {0}" , m_nDisciplineID);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvCommunication, dr, null, null);
dr.Close();
dgvCommunication.Columns["ID"].Visible = false;
}
catch (System.Exception e)
{
UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
}
}
private void ShowEventToGrid()
{
if (m_RecordModule.DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_RecordModule.DatabaseConnection.Open();
}
#region DML Command Setup for daEvent
SqlCommand cmd = new SqlCommand("Proc_GetDisciplineEvents", m_RecordModule.DatabaseConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.UpdatedRowSource = UpdateRowSource.None;
SqlParameter cmdParameter1 = new SqlParameter(
"@DisciplineID", SqlDbType.Int, 0,
ParameterDirection.Input, false, 0, 0, "@DisciplineID",
DataRowVersion.Current, m_iActiveDiscipline);
SqlParameter cmdParameter2 = new SqlParameter(
"@LanguageCode", SqlDbType.Char, 3,
ParameterDirection.Input, false, 0, 0, "@LanguageCode",
DataRowVersion.Current, m_strActiveLanguage);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
OVRDataBaseUtils.FillDataGridView(dgv_Events, dt);
}
private void Update_UnScheduledGrid()
{
int iFirstDisplayedScrollingRowIndex = dgv_UnScheduled.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgv_UnScheduled.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
System.Data.DataTable dt = GetUnScheduledDataTable();
OVRDataBaseUtils.FillDataGridView(this.dgv_UnScheduled, dt, null, null);
if (this.dgv_UnScheduled.Columns["F_EventID"] != null)
{
this.dgv_UnScheduled.Columns["F_EventID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_MatchID"] != null)
{
this.dgv_UnScheduled.Columns["F_MatchID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_SessionID"] != null)
{
this.dgv_UnScheduled.Columns["F_SessionID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_VenueID"] != null)
{
this.dgv_UnScheduled.Columns["F_VenueID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_CourtID"] != null)
{
this.dgv_UnScheduled.Columns["F_CourtID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_MatchStatusID"] != null)
{
this.dgv_UnScheduled.Columns["F_MatchStatusID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_RoundID"] != null)
{
this.dgv_UnScheduled.Columns["F_RoundID"].Visible = false;
}
this.dgv_UnScheduled.ClearSelection();
if (iFirstDisplayedScrollingRowIndex < dgv_UnScheduled.Rows.Count)
{
dgv_UnScheduled.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (iFirstDisplayedScrollingColumnIndex < dgv_UnScheduled.Columns.Count)
{
dgv_UnScheduled.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
}
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);
}
}
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);
}
}
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);
}
private void btnShowMatchResult_Click(object sender, EventArgs e)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = _OuterDBConnection;
string strSQL;
strSQL = ConfigurationManager.GetPluginSettingString("DV", "SQL_MatchResult");
if (strSQL.Length == 0)
{
strSQL = @"SELECT EventID, A.OrderNo, A.EventPoint, A.EventPlace, A.Qualified, A.Nonuser FROM dvOrder AS A WHERE A.EventID = '@MatchCode' ORDER BY EventPlace";
ConfigurationManager.SetPluginSettingString("DV", "SQL_MatchResult", strSQL);
}
strSQL = strSQL.Replace("@MatchCode", m_strOutMatchCode);
oneSqlCommand.CommandText = strSQL;
oneSqlCommand.CommandType = CommandType.Text;
if (_OuterDBConnection.State == System.Data.ConnectionState.Closed)
{
_OuterDBConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvImportInfo, sdr);
sdr.Close();
for (int i = 0; i < dgvImportInfo.Rows.Count; i++)
{
for (int j = 0; j < dgvImportInfo.Columns.Count; j++)
{
dgvImportInfo.Rows[i].Cells[j].ReadOnly = false;
}
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void btnShowActionCode_Click(object sender, EventArgs e)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = _OuterDBConnection;
string strSQL;
strSQL = ConfigurationManager.GetPluginSettingString("DV", "SQL_ActionCode");
if (strSQL.Length == 0)
{
strSQL = @"SELECT A.EventID, A.RoundNo, B.OrderNo, A.DiveCode1,A.DiveDiff, A.DiveHeight,c.DiverNameI, d.DiverNameI
FROM dvRound AS A LEFT JOIN dvOrder AS B ON A.DiverID1 = B.DiverID1 AND (A.DiverID2 IS NULL OR A.DiverID2 = '' OR A.DiverID2 = B.DiverID2) AND A.EventID = B.EventID
Left join dvDiver as c on a.DiverID1 = c.DiverID
Left join dvDiver as d on a.DiverID2 = d.DiverID
WHERE A.EventID = '@MatchCode' ORDER BY B.OrderNo, A.RoundNo" ;
ConfigurationManager.SetPluginSettingString("DV", "SQL_ActionCode", strSQL);
}
strSQL = strSQL.Replace("@MatchCode", m_strOutMatchCode);
oneSqlCommand.CommandText = strSQL;
oneSqlCommand.CommandType = CommandType.Text;
if (_OuterDBConnection.State == System.Data.ConnectionState.Closed)
{
_OuterDBConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvImportInfo, sdr);
sdr.Close();
for (int i = 0; i < dgvImportInfo.Rows.Count; i++)
{
for (int j = 0; j < dgvImportInfo.Columns.Count; j++)
{
dgvImportInfo.Rows[i].Cells[j].ReadOnly = false;
}
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (dgvCommunication.SelectedRows.Count <= 0)
{
return;
}
string strSectionName = "OfficialCommunication";
string strPromotion = LocalizationRecourceManager.GetString(strSectionName, "PromotionDelete");
if (DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion, "", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
int iSelRowsID = dgvCommunication.SelectedRows[0].Index;
int iNewsID = Convert.ToInt32(dgvCommunication.Rows[iSelRowsID].Cells["ID"].Value);
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Discipline Venues
String strSQL;
strSQL = String.Format(@"Delete TS_Offical_Communication
WHERE F_NewsID = {0}" , iNewsID);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvCommunication, dr, null, null);
dr.Close();
}
catch (System.Exception ex)
{
UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style);
}
UpdateGridView();
DataChangedNotify(OVRDataChangedType.emOfficialComDel, m_nDisciplineID, -1, -1, -1, iNewsID, null);
}
private void ShowRecordValuesToGrid(int nRecordID)
{
m_bUpdatingUI = true;
int iFirstDisplayedScrollingRowIndex = dgvRecordValue.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgvRecordValue.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
SqlDataReader dbReader = GetRecordValues(nRecordID, m_RecordModule.DatabaseConnection);
if (dbReader == null)
{
return;
}
OVRDataBaseUtils.FillDataGridView(dgvRecordValue, dbReader, null, null);
dbReader.Close();
// Edit Enable
foreach (DataGridViewColumn Col in dgvRecordValue.Columns)
{
if (Col.Name != "F_RecordID" && Col.Name != "F_ValueNum")
{
Col.ReadOnly = false;
}
}
if (iFirstDisplayedScrollingRowIndex < dgvRecordValue.Rows.Count)
{
dgvRecordValue.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (dgvRecordValue.FirstDisplayedScrollingColumnIndex < iFirstDisplayedScrollingColumnIndex &&
iFirstDisplayedScrollingColumnIndex < dgvEventRecords.Columns.Count)
{
dgvRecordValue.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
m_bUpdatingUI = false;
}
private int RefreshUI()
{
string strXml = GetMatchCodeXml();
if (strXml == "")
{
return(-1);
}
DataTable dt = BDCommon.g_ManageDB.GetMatchInfoFromRscXml(strXml);
if (dt == null)
{
return(-2);
}
OVRDataBaseUtils.FillDataGridView(dgMatchInfo, dt);
return(1);
}
public void ResetAvailableOfficial(int iMatchID, DataGridView dgv)
{
System.Data.SqlClient.SqlConnection con = GVAR.g_adoDataBase.DBConnect;
if (con.State != ConnectionState.Open)
{
con.Open();
}
try
{
#region DML Command Setup for Get AvailbleOfficial
SqlCommand cmd = new SqlCommand("Proc_AR_GetAvailableOfficial", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = m_iDisciplineID;
cmdParameter1.Value = iMatchID;
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgv, dr, null, null);
if (dgv.RowCount >= 0)
{
dgv.Columns["F_RegisterID"].Visible = false;
dgv.Columns["F_FunctionID"].Visible = false;
dgv.Columns["F_OfficialGroupID"].Visible = false;
dgv.Columns["F_PositionID"].Visible = false;
dgv.Columns["Group"].Visible = false;
}
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void OVRVenueListForm_Load(object sender, EventArgs e)
{
Localization();
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
int iActiveSport, iActiveDiscipline;
string strLanguageCode;
OVRDataBaseUtils.GetActiveInfo(sqlConnection, out iActiveDiscipline, out iActiveDiscipline, out strLanguageCode);
#region DML Command Setup for Get Discipline Venues
String strSQL;
strSQL = String.Format(@" SELECT 'NONE' AS [Venue]
UNION
SELECT C.F_VenueCode + '('+ B.F_VenueLongName + ')' AS [Venue]
FROM TD_Discipline_Venue AS A
LEFT JOIN TC_Venue_Des AS B ON A.F_VenueID = B.F_VenueID
LEFT JOIN TC_Venue AS C ON A.F_VenueID = C.F_VenueID
WHERE B.F_LanguageCode = '{0}' AND A.F_DisciplineID = {1}" , strLanguageCode, iActiveDiscipline);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
#endregion
SqlDataReader dr = null;
try
{
dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvVenueList, dr, null, null);
dr.Close();
}
catch (System.Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
}
}
private void btnStartCheck_Click(object sender, EventArgs e)
{
if (dgvToCheckErr.Rows.Count == 0)
{
MessageBoxEx.Show("Please select items which you want to check.");
return;
}
foreach (DataGridViewRow dgvr in dgvToCheckErr.Rows)
{
dgvr.Cells[1].Value = "Not Checked";
}
string lang = cmbLang.SelectedIndex == 0 ? "ENG" : "CHN";
dgvToCheckErr.ClearSelection();
for (int i = 0; i < dgvToCheckErr.Rows.Count; i++)
{
string strItem = dgvToCheckErr.Rows[i].Cells[0].Value.ToString();
string status = dgvToCheckErr.Rows[i].Cells[1].Value.ToString();
dgvToCheckErr.Rows[i].Selected = true;
dgvToCheckErr.CurrentCell = dgvToCheckErr.Rows[i].Cells[0];
DataTable dtRes = BDCommon.g_ManageDB.GetSelfCheckError(strItem, lang);
if (dtRes != null)
{
dgvToCheckErr.Rows[i].Cells[1].Value = "Checked Error";
OVRDataBaseUtils.FillDataGridView(dgvCheckResult, dtRes);
dgvToCheckErr.ClearSelection();
dgvCheckResult.ClearSelection();
MessageBoxEx.Show("Find an error!If you want to continue,fix it first.");
return;
}
else
{
dgvToCheckErr.Rows[i].Cells[1].Value = "Checked Succeed";
}
System.Windows.Forms.Application.DoEvents();
System.Threading.Thread.Sleep(50);
dgvToCheckErr.ClearSelection();
}
dgvCheckResult.Rows.Clear();
MessageBoxEx.Show("All check succeed!");
}
private void frmImportTempData_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable("Sets");
dt.Columns.Add("FileName", typeof(string));
dt.Columns.Add("Set", typeof(string));
string strMatchID = m_iMatchID.ToString();
strMatchID = strMatchID.PadLeft(5, '0');
string[] strFiles = Directory.GetFiles(BDCommon.GetTempMatchDir(), string.Format("9?{0}_Result.xml", strMatchID));
foreach (string strFilePath in strFiles)
{
string strName = Path.GetFileName(strFilePath);
DataRow drNew = dt.NewRow();
drNew["FileName"] = strName;
drNew["Set"] = strName.Substring(1, 1);
dt.Rows.Add(drNew);
}
OVRDataBaseUtils.FillDataGridView(dgvTempSetData, dt);
}
private void Init_UnScheduledGrid()
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgv_UnScheduled);
System.Data.DataTable dt = GetInitUnScheduledDataTable();
OVRDataBaseUtils.FillDataGridView(this.dgv_UnScheduled, dt, null, null);
if (this.dgv_UnScheduled.Columns["F_EventID"] != null)
{
this.dgv_UnScheduled.Columns["F_EventID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_MatchID"] != null)
{
this.dgv_UnScheduled.Columns["F_MatchID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_SessionID"] != null)
{
this.dgv_UnScheduled.Columns["F_SessionID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_VenueID"] != null)
{
this.dgv_UnScheduled.Columns["F_VenueID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_CourtID"] != null)
{
this.dgv_UnScheduled.Columns["F_CourtID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_MatchStatusID"] != null)
{
this.dgv_UnScheduled.Columns["F_MatchStatusID"].Visible = false;
}
if (this.dgv_UnScheduled.Columns["F_RoundID"] != null)
{
this.dgv_UnScheduled.Columns["F_RoundID"].Visible = false;
}
this.dgv_UnScheduled.ClearSelection();
}
private void ResetCommetGrid()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Reset CommentGrid
string strSQL = String.Format(@"SELECT F_Comment_Order AS [Order], F_Title AS [Title], F_Comment AS [Comment],F_CommentID AS [ID]
FROM TR_Register_Comment WHERE F_RegisterID = {0}" , m_iRegisterID);
SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
SqlDataReader dr = cmd.ExecuteReader();
#endregion
OVRDataBaseUtils.FillDataGridView(dgvComment, dr, null, null);
dr.Close();
if (dgvComment.Rows.Count > 0)
{
if (m_iSelRowIdx < 0)
{
return;
}
else if (m_iSelRowIdx > dgvComment.RowCount - 1)
{
m_iSelRowIdx = dgvComment.RowCount - 1;
}
dgvComment.Rows[m_iSelRowIdx].Selected = true;
dgvComment.FirstDisplayedScrollingRowIndex = m_iSelRowIdx;
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void ResetPhaseCompetitors()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get AvailbleMember
SqlCommand cmd = new SqlCommand("proc_GetCompetitorsForPhase", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@EventID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@PhaseID", SqlDbType.Int);
SqlParameter cmdParameter3 = new SqlParameter("@NodeType", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = m_iEventID;
cmdParameter1.Value = m_iPhaseID;
cmdParameter3.Value = m_iNodeType;
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter3);
cmd.Parameters.Add(cmdParameter2);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvPhaseCompetitors, dr, null, null);
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void ShowRecordMembersToGrid(int nRecordID)
{
m_bUpdatingUI = true;
int iFirstDisplayedScrollingRowIndex = dgvRecordMember.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgvRecordMember.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
SqlDataReader dbReader = GetRecordMember(nRecordID, m_RecordModule.DatabaseConnection);
if (dbReader == null)
{
return;
}
OVRDataBaseUtils.FillDataGridView(dgvRecordMember, dbReader, null, null);
dbReader.Close();
if (iFirstDisplayedScrollingRowIndex < dgvRecordMember.Rows.Count)
{
dgvRecordMember.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (dgvEventRecords.FirstDisplayedScrollingColumnIndex < iFirstDisplayedScrollingColumnIndex &&
iFirstDisplayedScrollingColumnIndex < dgvRecordMember.Columns.Count)
{
dgvRecordMember.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
m_bUpdatingUI = false;
}
private void ShowEventRecordToGrid()
{
m_bUpdatingUI = true;
int iFirstDisplayedScrollingRowIndex = dgvEventRecords.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgvEventRecords.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
SqlDataReader dbReader = GetEventRecords(GetCurSelEventID(), m_RecordModule.DatabaseConnection);
if (dbReader == null)
{
return;
}
List <OVRCheckBoxColumn> lstChkColumns = new List <OVRCheckBoxColumn>();
for (int j = 0; j < dbReader.FieldCount; j++)
{
if ("F_Active" == dbReader.GetName(j) || "F_Equalled" == dbReader.GetName(j) || "F_IsNewCreated" == dbReader.GetName(j))
{
lstChkColumns.Add(new OVRCheckBoxColumn(j, 1, 0));
}
}
List <int> lstCmbColumns = new List <int>();
for (int j = 0; j < dbReader.FieldCount; j++)
{
if ("F_RecordType" == dbReader.GetName(j))
{
lstCmbColumns.Add(j);
}
}
OVRDataBaseUtils.FillDataGridView(dgvEventRecords, dbReader, lstCmbColumns, lstChkColumns);
//OVRDataBaseUtils.FillDataGridViewWithCmb(dgvEventRecords, dbReader, "F_Equalled");
dbReader.Close();
// Edit Enable
foreach (DataGridViewColumn Col in dgvEventRecords.Columns)
{
if (Col.Name == "F_EventID" || Col.Name == "F_RecordID")
{
Col.Visible = false;
}
else
{
Col.ReadOnly = false;
}
}
// Edit Enable
foreach (DataGridViewColumn Col in dgvEventRecords.Columns)
{
if (Col.Name == "F_Active" || Col.Name == "F_RecordType" || Col.Name == "F_Equalled" || Col.Name == "F_IsNewCreated" ||
Col.Name == "F_RecordDate" || Col.Name == "F_Order" || Col.Name == "F_Location" || Col.Name == "F_RecordSport" ||
Col.Name == "F_RecordComment" || Col.Name == "F_RecordValue")
{
Col.ReadOnly = false;
}
}
if (iFirstDisplayedScrollingRowIndex < dgvEventRecords.Rows.Count)
{
dgvEventRecords.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (dgvEventRecords.FirstDisplayedScrollingColumnIndex < iFirstDisplayedScrollingColumnIndex &&
iFirstDisplayedScrollingColumnIndex < dgvEventRecords.Columns.Count)
{
dgvEventRecords.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
m_bUpdatingUI = false;
}
private void btnShowDetailResult_Click(object sender, EventArgs e)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = _OuterDBConnection;
string strSQL;
strSQL = ConfigurationManager.GetPluginSettingString("DV", "SQL_DetailMatchResult");
if (strSQL.Length == 0)
{
strSQL = @"SELECT A.EventID AS EventCode
, CAST(B.RoundNo AS NVARCHAR(20)) AS RoundNo
, A.OrderNo AS OrderNo
, DivePoint AS DivePoints
, DiveRank AS DiveRank
, B.EventPoint AS EventPoint
, B.EventPlace AS EventRank
, 10 AS MatchsplitTypeID
, NULL AS JudgeGroup
, NULL AS JudgePanel
FROM dvOrder AS A LEFT JOIN dvRound AS B ON A.EventID = B.EventID AND A.DiverID1 = B.DiverID1 AND (A.DiverID2 IS NULL OR A.DiverID2 = '' OR A.DiverID2 = B.DiverID2)
WHERE A.EventID = '@MatchCode' AND (@RoundNo= 0 OR B.RoundNo = @RoundNo )
UNION
SELECT A.EventID AS EventCode
, CAST(B.RoundNo AS NVARCHAR(20)) + '0'+ CAST(B.JudgeGroup AS NVARCHAR(20)) + '0' + CAST (B.JudgePanelDes AS NVARCHAR(20)) RoundNo
, B.OrderNo AS OrderNo
, B.JudgeAward AS DivePoints
, NULL AS DiveRank
, NULL AS EventPoint
, NULL AS EventRank
, 31 AS MatchsplitTypeID
, B.JudgeGroup AS JudgeGroup
, B.JudgePanelDes AS JudgePanel
FROM dvOrder AS A
LEFT JOIN (SELECT RoundNo, OrderNo, EventID, JudgeAward, JudgeGroup, ROW_NUMBER() OVER(PARTITION BY EventID, RoundNo,OrderNo,JudgeGroup ORDER BY JudgePanel) AS JudgePanelDes FROM dvAward ) AS B ON A.OrderNo = B.OrderNo AND A.EventID = B.EventID
WHERE A.EventID = '@MatchCode' AND (@RoundNo = 0 OR B.RoundNo = @RoundNo) ORDER BY OrderNo";
ConfigurationManager.SetPluginSettingString("DV", "SQL_DetailMatchResult", strSQL);
}
strSQL = strSQL.Replace("@MatchCode", m_strOutMatchCode);
strSQL = strSQL.Replace("@RoundNo", m_strRoundNo);
oneSqlCommand.CommandText = strSQL;
oneSqlCommand.CommandType = CommandType.Text;
if (_OuterDBConnection.State == System.Data.ConnectionState.Closed)
{
_OuterDBConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvImportInfo, sdr);
sdr.Close();
for (int i = 0; i < dgvImportInfo.Rows.Count; i++)
{
for (int j = 0; j < dgvImportInfo.Columns.Count; j++)
{
dgvImportInfo.Rows[i].Cells[j].ReadOnly = false;
}
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
//From LiYan
public void ResetMemberGrid(int iMatchID, int iTeamID, int iTeamPos, ref DataGridView dgv, ref int iStartupNumber)
{
if (Common.g_DataBaseCon.State == System.Data.ConnectionState.Closed)
{
Common.g_DataBaseCon.Open();
}
try
{
#region DML Command Setup for Get MatchMember
SqlCommand cmd = new SqlCommand("Proc_VB_EXT_MatchMemberGetList", Common.g_DataBaseCon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter3 = new SqlParameter("@TeamPos", SqlDbType.Int);
cmdParameter1.Value = iMatchID;
cmdParameter2.Value = Common.g_strLanguage;
cmdParameter3.Value = iTeamPos;
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameter3);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
int iSelRowIndex = -1;
if (dgv.Rows.Count > 0 && dgv.SelectedRows != null)
{
// iSelRowIndex = dgv.SelectedRows[0].Index;
}
List <int> lstCmbColumns = new List <int>();
lstCmbColumns.Add(3);
lstCmbColumns.Add(5);
lstCmbColumns.Add(6);
List <OVRCheckBoxColumn> lstChkColumns = new List <OVRCheckBoxColumn>();
lstChkColumns.Add(new OVRCheckBoxColumn(0, 1, 0));
OVRDataBaseUtils.FillDataGridView(dgv, dr, lstCmbColumns, lstChkColumns);
dr.Close();
if (dgv.RowCount > 0)
{
dgv.Columns["F_MemberID"].Visible = false;
dgv.Columns["F_StartupNum"].Visible = false;
dgv.Columns["Order"].ReadOnly = false;
dgv.Columns["ShirtNumber"].ReadOnly = false;
dgv.Columns["DSQ"].ReadOnly = false;
dgv.Columns["Startup"].Visible = false;
dgv.Columns["MaxServeSpeed"].ReadOnly = false;
iStartupNumber = Common.Str2Int(dgv.Rows[0].Cells["F_StartupNum"].Value);
dgv.ClearSelection();
if (iSelRowIndex > 0 && iSelRowIndex < dgv.Rows.Count)
{
dgv.Rows[iSelRowIndex].Selected = true;
}
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void ResetPictureGrid()
{
if (this.DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
this.DatabaseConnection.Open();
}
try
{
int iFirstDisplayedScrollingRowIndex = dgvPicture.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgvPicture.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
#region DML Command Setup for Get Picture List
SqlCommand cmd = new SqlCommand("Proc_GetPictureInfo", this.DatabaseConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
m_bUpdate = true;
OVRDataBaseUtils.FillDataGridView(dgvPicture, dr, null, null);
m_bUpdate = false;
dr.Close();
#endregion
if (dgvPicture.Columns.Count <= 0)
{
return;
}
dgvPicture.Columns["FileCode"].ReadOnly = false;
dgvPicture.Columns["FileComment"].ReadOnly = false;
dgvPicture.Columns["FileType"].ReadOnly = false;
dgvPicture.Columns["ID"].Visible = false;
dgvPicture.ClearSelection();
if (m_iSelPicRowIndex >= 0 && m_iSelPicRowIndex < dgvPicture.Rows.Count)
{
dgvPicture.Rows[m_iSelPicRowIndex].Selected = true;
}
if (iFirstDisplayedScrollingRowIndex < dgvPicture.Rows.Count)
{
dgvPicture.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (dgvPicture.FirstDisplayedScrollingColumnIndex < iFirstDisplayedScrollingColumnIndex &&
iFirstDisplayedScrollingColumnIndex < dgvPicture.Columns.Count)
{
dgvPicture.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}