private void GetActiveDisciplineID()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Active Discipline
SqlCommand cmdDiscipline = new SqlCommand("Proc_GetActiveDiscipline", sqlConnection);
cmdDiscipline.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmdDiscipline.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
m_strDisciplineID = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_DisciplineID");
}
}
dr.Close();
#endregion
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void ResetMemberGrid()
{
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
#region DML Command Setup for Get Member
int nRegisterID = Convert.ToInt32(m_strRegisterID);
int nDisciplineID = Convert.ToInt32(strDisciplineID);
SqlCommand cmd = new SqlCommand("Proc_GetMember_WithOrder", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.UpdatedRowSource = UpdateRowSource.None;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@RegisterID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = Convert.ToInt32(strDisciplineID);
cmdParameter1.Value = Convert.ToInt32(m_strRegisterID);
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvMember, dr, 3, 4);
dr.Close();
SetGridStyle(dgvMember);
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
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 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 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 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 GetCommunicationContext()
{
if (m_iNewsID <= 0)
{
return;
}
if (DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
SqlCommand cmd = new SqlCommand("Proc_GetOfficialCommunication", DatabaseConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@NewsID", SqlDbType.Int);
cmdParameter1.Value = m_iNewsID;
cmd.Parameters.Add(cmdParameter1);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
textItem.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_NewsItem");
textSubTitle.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_SubTitle");
textHeading.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Heading");
textText.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Text");
textIssuedBy.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Issued_by");
cmbOCType.SelectedValue = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Type");
dtOCDate.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Date");
textNote.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Note");
cmbReportTitle.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_ReportTitle");
txtSummary.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Summary");
txtDetails.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Details");
}
}
dr.Close();
}
catch (System.Exception e)
{
UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
}
}
private void GetMFInfo()
{
if (m_dbConnect.State == System.Data.ConnectionState.Closed)
{
m_dbConnect.Open();
}
try
{
#region DML Command Setup for Get MFInfo
SqlCommand cmd = new SqlCommand("Proc_EQ_GetMFID", m_dbConnect);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@MFID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter1.Value = m_iInfoID;
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
m_strLongName = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_MFLongName");
m_strShortName = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_MFShortName");
}
}
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public string GetCurActivedLanguageCode()
{
if (m_genDataModule.DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_genDataModule.DatabaseConnection.Open();
}
string strSQLDes;
strSQLDes = "SELECT F_LanguageCode FROM TC_Language WHERE F_Active = 1";
SqlCommand cmd = new SqlCommand(strSQLDes, m_genDataModule.DatabaseConnection);
string strLanguage = "";
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
strLanguage = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_LanguageCode");
}
dr.Close();
return(strLanguage);
}
private void FillComboBox(DevComponents.DotNetBar.Controls.ComboBoxEx combo, SqlDataReader dr, String strValue)
{
combo.Items.Clear();
if (dr.HasRows)
{
int nItemIdx = 0;
int nSelItemIdx = -1;
while (dr.Read())
{
ComboBoxItem item = new ComboBoxItem();
if (dr.FieldCount >= 2)
{
item.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, dr.GetName(0));
item.Tag = OVRDataBaseUtils.GetFieldValue2String(ref dr, dr.GetName(1));
}
else if (dr.FieldCount == 1)
{
item.Text = OVRDataBaseUtils.GetFieldValue2String(ref dr, dr.GetName(0));
item.Tag = OVRDataBaseUtils.GetFieldValue2String(ref dr, dr.GetName(0));
}
combo.Items.Add(item);
if (item.Tag.ToString().CompareTo(strValue) == 0)
{
nSelItemIdx = nItemIdx;
}
nItemIdx++;
}
if (nSelItemIdx >= 0)
{
combo.Text = combo.Items[nSelItemIdx].ToString();
}
}
}
private void InitCompetitionPositionById(Int32 iMatchID, Int32 iCompetitionPosition, String strLanguageCode)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetCompetitionPositionInfo";
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(
"@CompetitionPosition", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iCompetitionPosition);
oneSqlCommand.Parameters.Add(cmdParameter2);
SqlParameter cmdParameter3 = new SqlParameter(
"@LanguageCode", SqlDbType.Char, 3,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, strLanguageCode);
oneSqlCommand.Parameters.Add(cmdParameter3);
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
TextMatchName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchLongName");
TextPositionDes1.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_CompetitionPositionDes1");
TextPositionDes2.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_CompetitionPositionDes2");
TextPositionSourceDes.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_CompetitorSourceDes");
CmbCompetitor.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_RegisterID");
CmbStartPhase.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_StartPhaseID");
TextPhasePosition.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_StartPhasePosition");
CmbSourcePhase.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_SourcePhaseID");
TextPhaseRank.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_SourcePhaseRank");
CmbSourcePhaseForMatch.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_SourcePhaseID");
CmbSourceMatch.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_SourceMatchID");
TextMatchRank.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_SourceMatchRank");
CmbSourcePhaseforHistoryMatch.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_SourcePhaseID");
CmbHistoryMatch.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_HistoryMatchID");
TextHistoryMatchRank.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_HistoryMatchRank");
TextHistoryLevel.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_HistoryLevel");
TextSourceProgress.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_SouceProgressDes");
TextProgress.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_ProgressDes");
m_iPositionSourceType = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "PositionSourceType");
//IntiSourceControls(m_iPositionSourceType);
switch (m_iPositionSourceType)
{
case 1:
RadioFromPhasePosition.Checked = true;
break;
case 2:
RadioFromPhaseRank.Checked = true;
break;
case 3:
RadioFromMatchRank.Checked = true;
break;
case 4:
RadioFromMatchHistory.Checked = true;
break;
case 0:
RadioFromPhasePosition.Checked = false;
RadioFromPhaseRank.Checked = false;
RadioFromMatchRank.Checked = false;
RadioFromMatchHistory.Checked = false;
break;
}
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void FillFunctionComboBox(int iMemberID)
{
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();
int nDisciplineID = Convert.ToInt32(strDisciplineID);
#endregion
#region DML Command Setup for Register RegType
string strRegType = "";
string strSQL = string.Format("SELECT F_RegTypeID FROM TR_Register WHERE F_RegisterID = {0}", iMemberID);
SqlCommand RegTypecmd = new SqlCommand(strSQL, sqlConnection);
dr = RegTypecmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
strRegType = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_RegTypeID");
}
}
dr.Close();
#endregion
#region DML Command Setup for Fill Function combo
SqlCommand cmd = new SqlCommand("Proc_GetFunctionInfo", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter2 = new SqlParameter("@RegType", SqlDbType.Int);
cmdParameter0.Value = nDisciplineID;
cmdParameter1.Value = m_strLanguageCode;
if (strRegType.Length == 0)
{
cmdParameter2.Value = DBNull.Value;
}
else
{
cmdParameter2.Value = Convert.ToInt32(strRegType);
}
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
dr = cmd.ExecuteReader();
#endregion
DataTable table = new DataTable();
table.Columns.Add("F_Name", typeof(string));
table.Columns.Add("F_Key", typeof(int));
table.Load(dr);
(dgvMember.Columns[3] as DGVCustomComboBoxColumn).FillComboBoxItems(table, "F_Name", "F_Key");
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void InitPhaseById(Int32 iPhaseID, String strLanguageCode)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetPhaseInfo";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@PhaseID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iPhaseID);
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_PhaseCode");
DateStart.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_OpenDate");
DateEnd.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_CloseDate");
TextOrder.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_Order");
textIsPool.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_PhaseIsPool");
textHasPools.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_PhaseHasPools");
TextLongName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_PhaseLongName");
TextShortName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_PhaseShortName");
TextComment.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_PhaseComment");
CmbStatus.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_PhaseStatusID");
m_strIniPhaseCode = TextCode.Text;
m_strIniDateStart = DateStart.Text;
m_strIniDateEnd = DateEnd.Text;
m_strIniOrder = TextOrder.Text;
m_strIniIsPool = textIsPool.Text;
m_strIniHasPool = textHasPools.Text;
m_strIniLongName = TextLongName.Text;
m_strIniShortName = TextShortName.Text;
m_strIniComment = TextComment.Text;
m_strIniStatusID = CmbStatus.SelectedValue.ToString();
m_iEventID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_EventID");
m_iPhaseID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_PhaseID");
m_iFatherPhaseID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_FatherPhaseID");
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void RefreshPhaseTree()
{
advTree.BeginUpdate();
advTree.Nodes.Clear();
DevComponents.AdvTree.Node oLastSelNode = null;
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_matchScheduleModule.DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetScheduleTree";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@ID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "@ID",
DataRowVersion.Current, m_strDisciplineID);
oneSqlCommand.Parameters.Add(cmdParameter1);
SqlParameter cmdParameter2 = new SqlParameter(
"@Type", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "@Type",
DataRowVersion.Current, -5);
oneSqlCommand.Parameters.Add(cmdParameter2);
SqlParameter cmdParameter3 = new SqlParameter(
"@LanguageCode", SqlDbType.Char, 3,
ParameterDirection.Input, true, 0, 0, "@LanguageCode",
DataRowVersion.Current, m_strActiveLanguageCode);
oneSqlCommand.Parameters.Add(cmdParameter3);
if (m_matchScheduleModule.DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_matchScheduleModule.DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
int cols = sdr.FieldCount; //获取结果行中的列数
object[] values = new object[cols];
if (sdr.HasRows)
{
while (sdr.Read())
{
String strNodeName = "";
String strNodeKey = "";
String strFatherNodeKey = "";
int iNodeType = -5;//-4表示所有Sport, -3表示Sport，-2表示Discipline，-1表示Event，0表示Phase
int iSportID = 0;
int iDisciplineID = 0;
int iEventID = 0;
int iPhaseID = 0;
int iPhaseType = 0;
int iPhaseSize = 0;
int iFatherPhaseID = 0;
int iMatchID = 0;
int nImage = 0;
int nSelectedImage = 0;
strNodeName = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_NodeName");
strNodeKey = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_NodeKey");
strFatherNodeKey = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_FatherNodeKey");
iNodeType = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_NodeType");
iSportID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_SportID");
iDisciplineID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_DisciplineID");
iEventID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_EventID");
iPhaseID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_PhaseID");
iPhaseType = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_PhaseType");
iPhaseSize = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_PhaseSize");
iFatherPhaseID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_FatherPhaseID");
iMatchID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_MatchID");
nImage = iNodeType + 3;
nSelectedImage = iNodeType + 3;
SAxTreeNodeInfo oneSNodeInfo = new SAxTreeNodeInfo();
oneSNodeInfo.strNodeKey = strNodeKey;
oneSNodeInfo.iNodeType = iNodeType;
oneSNodeInfo.iSportID = iSportID;
oneSNodeInfo.iDisciplineID = iDisciplineID;
oneSNodeInfo.iEventID = iEventID;
oneSNodeInfo.iPhaseID = iPhaseID;
oneSNodeInfo.iPhaseType = iPhaseType;
oneSNodeInfo.iPhaseSize = iPhaseSize;
oneSNodeInfo.iFatherPhaseID = iFatherPhaseID;
oneSNodeInfo.iMatchID = iMatchID;
DevComponents.AdvTree.Node oneNode = new DevComponents.AdvTree.Node();
oneNode.Text = strNodeName;
oneNode.ImageIndex = nImage;
oneNode.ImageExpandedIndex = nSelectedImage;
oneNode.Tag = oneSNodeInfo;
oneNode.DataKey = strNodeKey;
if (oneSNodeInfo.iNodeType == -3)
{
oneNode.Expanded = true;
}
if (oneSNodeInfo.iNodeType == -2 && oneSNodeInfo.iDisciplineID == m_iActiveDisciplineID)
{
oneNode.Expanded = true;
}
DevComponents.AdvTree.Node FatherNode = advTree.FindNodeByDataKey(strFatherNodeKey);
if (FatherNode == null)
{
advTree.Nodes.Add(oneNode);
}
else
{
FatherNode.Nodes.Add(oneNode);
}
if (m_strLastSelPhaseTreeNodeKey == strNodeKey)
{
oLastSelNode = oneNode;
oneNode.Expanded = true;
// Expand All Parent Node
DevComponents.AdvTree.Node node = oLastSelNode;
while (node.Parent != null)
{
node.Parent.Expanded = true;
node = node.Parent;
}
}
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
advTree.EndUpdate();
advTree.SelectedNode = oLastSelNode;
}
