bool AddSession(string strDate) { try { System.Data.SqlClient.SqlConnection con = m_sqlCon; if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand cmd = new SqlCommand("Proc_Schedule_AddSession", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@DisciplineID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DisciplineID", DataRowVersion.Current, m_strDisciplineID)); cmd.Parameters.Add(new SqlParameter("@SessionDate", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionDate", DataRowVersion.Current, strDate)); cmd.Parameters.Add(new SqlParameter("@SessionNumber", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@SessionNumber", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@SessionTime", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionTime", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@SessionEndTime", SqlDbType.Char, 10, ParameterDirection.Input, true, 0, 0, "@SessionEndTime", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@SeesionTypeID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@SeesionTypeID", DataRowVersion.Current, DBNull.Value)); SqlParameter cmdParameterResult = new SqlParameter("@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0); cmd.Parameters.Add(cmdParameterResult); cmd.UpdatedRowSource = UpdateRowSource.None; cmd.ExecuteNonQuery(); if (cmdParameterResult.Value != null && (Int32)cmdParameterResult.Value > 0) { if (module != null) { int iDisciplineID = Convert.ToInt32(m_strDisciplineID); int iSessionID = Convert.ToInt32(cmdParameterResult.Value); module.DataChangedNotify(OVRDataChangedType.emSessionAdd, iDisciplineID, -1, -1, -1, iSessionID, null); } return(true); } else { return(false); } } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); return(false); } }
int AddDate(string strDate) { try { System.Data.SqlClient.SqlConnection con = m_sqlCon; if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand cmd = new SqlCommand("Proc_Schedule_AddDisciplineDate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@DisciplineID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DisciplineID", DataRowVersion.Current, m_strDisciplineID)); cmd.Parameters.Add(new SqlParameter("@DateOrder", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "@DateOrder", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "@Date", DataRowVersion.Current, strDate)); cmd.Parameters.Add(new SqlParameter("@DateLongDescription", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "@DateLongDescription", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@DateShortDescription", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "@DateShortDescription", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@DateComment", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "@DateComment", DataRowVersion.Current, DBNull.Value)); cmd.Parameters.Add(new SqlParameter("@LanguageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "@LanguageCode", DataRowVersion.Current, m_strLanguageCode)); SqlParameter cmdParameterResult = new SqlParameter("@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0); cmd.Parameters.Add(cmdParameterResult); cmd.UpdatedRowSource = UpdateRowSource.None; cmd.ExecuteNonQuery(); if (cmdParameterResult.Value != null && (Int32)cmdParameterResult.Value > 0) { if (module != null) { int iDisciplineID = Convert.ToInt32(m_strDisciplineID); int iDateID = Convert.ToInt32(cmdParameterResult.Value); module.DataChangedNotify(OVRDataChangedType.emDateAdd, iDisciplineID, -1, -1, -1, iDateID, null); } } return(int.Parse(cmdParameterResult.Value.ToString())); } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); return(0); } }
private bool EditCompetitionPosition() { bool bResult = false; try { Int32 iOperateResult; SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = m_DatabaseConnection; oneSqlCommand.CommandText = "proc_EditCompetitionPosition"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter0 = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_iMatchID); oneSqlCommand.Parameters.Add(cmdParameter0); SqlParameter cmdParameter2 = new SqlParameter( "@CompetitionPosition", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_iCompetitionPosition); oneSqlCommand.Parameters.Add(cmdParameter2); SqlParameter cmdParameter3 = new SqlParameter( "@CompetitionPositionDes1", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextPositionDes1.Text)); oneSqlCommand.Parameters.Add(cmdParameter3); SqlParameter cmdParameter4 = new SqlParameter( "@CompetitionPositionDes2", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextPositionDes2.Text)); oneSqlCommand.Parameters.Add(cmdParameter4); SqlParameter cmdParameter5 = new SqlParameter( "@RegisterID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbCompetitor.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter5); SqlParameter cmdParameter6 = new SqlParameter( "@PositionSourceDes", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextPositionSourceDes.Text); oneSqlCommand.Parameters.Add(cmdParameter6); SqlParameter cmdParameter7 = new SqlParameter( "@StartPhaseID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbStartPhase.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter7); SqlParameter cmdParameter8 = new SqlParameter( "@StartPhasePosition", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextPhasePosition.Text)); oneSqlCommand.Parameters.Add(cmdParameter8); SqlParameter cmdParameter9 = new SqlParameter( "@SourcePhaseID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbSourcePhase.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter9); SqlParameter cmdParameter10 = new SqlParameter( "@PhaseRank", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextPhaseRank.Text)); oneSqlCommand.Parameters.Add(cmdParameter10); SqlParameter cmdParameter11 = new SqlParameter( "@SourceMatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbSourceMatch.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter11); SqlParameter cmdParameter12 = new SqlParameter( "@MatchRank", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextMatchRank.Text)); oneSqlCommand.Parameters.Add(cmdParameter12); SqlParameter cmdParameter13 = new SqlParameter( "@HistoryMatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbHistoryMatch.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter13); SqlParameter cmdParameter14 = new SqlParameter( "@HistoryMatchRank", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextHistoryMatchRank.Text)); oneSqlCommand.Parameters.Add(cmdParameter14); SqlParameter cmdParameter15 = new SqlParameter( "@HistoryLevel", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(TextHistoryLevel.Text)); oneSqlCommand.Parameters.Add(cmdParameter15); SqlParameter cmdParameter16 = new SqlParameter( "@languageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_strLanguageCode); oneSqlCommand.Parameters.Add(cmdParameter16); SqlParameter cmdParameter17 = new SqlParameter( "@PositionSourceType", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_iPositionSourceType); oneSqlCommand.Parameters.Add(cmdParameter17); SqlParameter cmdParameter18 = new SqlParameter( "@SouceProgressDes", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextSourceProgress.Text.ToString()); oneSqlCommand.Parameters.Add(cmdParameter18); SqlParameter cmdParameter19 = new SqlParameter( "@ProgressDes", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextProgress.Text.ToString()); oneSqlCommand.Parameters.Add(cmdParameter19); SqlParameter cmdParameterResult = new SqlParameter( "@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0); oneSqlCommand.Parameters.Add(cmdParameterResult); if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed) { m_DatabaseConnection.Open(); } if (oneSqlCommand.ExecuteNonQuery() != 0) { iOperateResult = (Int32)cmdParameterResult.Value; switch (iOperateResult) { case 0: DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditCompetitionPosition1")); bResult = false; break; case -1: DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditCompetitionPosition2")); bResult = false; break; default: //其余的需要为修改成功! if (m_Module != null) { m_Module.DataChangedNotify(OVRDataChangedType.emMatchCompetitor, -1, -1, -1, m_iMatchID, m_iCompetitionPosition, null); } m_bEditCompetitionPosition = true; bResult = true; break; } } } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); } return(bResult); }
private void AddDisciplineVenue(int iDisciplineID, int iVenueID) { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } try { #region DML Command Setup for Add RegisterMember SqlCommand cmd = new SqlCommand("Proc_AddVenueIntoDiscipline", sqlConnection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter1 = new SqlParameter( "@DisciplineID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@DisciplineID", DataRowVersion.Current, iDisciplineID); SqlParameter cmdParameter2 = new SqlParameter( "@VenueID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@VenueID", DataRowVersion.Default, iVenueID); SqlParameter cmdParameterResult = new SqlParameter( "@Result", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "@Result", DataRowVersion.Default, DBNull.Value); cmd.Parameters.Add(cmdParameter1); cmd.Parameters.Add(cmdParameter2); cmd.Parameters.Add(cmdParameterResult); cmd.UpdatedRowSource = UpdateRowSource.OutputParameters; #endregion cmd.ExecuteNonQuery(); int nRetValue = (int)cmd.Parameters["@Result"].Value; string strPromotion; switch (nRetValue) { case 0: strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_Failed"); DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion); break; case -1: strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForDis"); DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion); break; case -2: strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForVenue"); DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion); break; case -3: strPromotion = LocalizationRecourceManager.GetString(this.Name, "AddDisVenue_FailedForExists"); DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion); break; default: if (module != null) { module.DataChangedNotify(OVRDataChangedType.emVenueAdd, iDisciplineID, -1, -1, -1, iVenueID, null); } break; } } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }