コード例 #1
0
 public ForceTradition GetForceTradition(string ForceTraditionName)
 {
     return(GetSingleForceTradition("Select_ForceTradition", " ForceTraditionName = '" + ForceTraditionID.ToString() + "'", ""));
 }
コード例 #2
0
        public Organization SaveOrganization()
        {
            SqlDataReader      result;
            DatabaseConnection dbconn     = new DatabaseConnection();
            SqlCommand         command    = new SqlCommand();
            SqlConnection      connection = new SqlConnection(dbconn.SQLSEVERConnString);

            try
            {
                connection.Open();
                command.Connection  = connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "InsertUpdate_Organization";
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationID", SqlDbType.Int, OrganizationID.ToString(), 0));
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationName", SqlDbType.VarChar, OrganizationName, 100));
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationDescription", SqlDbType.VarChar, OrganizationDescription, 4000));
                command.Parameters.Add(dbconn.GenerateParameterObj("@ScaleID", SqlDbType.Int, ScaleID.ToString(), 0));
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationTypeID", SqlDbType.Int, OrganizationTypeID.ToString(), 0));
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationAllies", SqlDbType.VarChar, OrganizationAllies, 4000));
                command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationEnemies", SqlDbType.VarChar, OrganizationEnemies, 4000));
                command.Parameters.Add(dbconn.GenerateParameterObj("@ForceTraditionID", SqlDbType.Int, ForceTraditionID.ToString(), 0));
                result = command.ExecuteReader();

                result.Read();
                SetReaderToObject(ref result);
            }
            catch
            {
                Exception e = new Exception();
                this._insertUpdateOK = false;
                this._insertUpdateMessage.Append(e.Message.ToString());
                throw e;
            }
            finally
            {
                command.Dispose();
                connection.Close();
            }
            return(this);
        }